Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “actt” with Change Limit: [1] [2] [3]

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

83 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
act59557841ac_t
acta69524801acta
acts66929861acts
att35454651a_tt
abet610547942abet
abut66834952abut
ace59656832ac_e
aced79540882aced
aces67645092aces
aceta74017352aceta
ache96829822ache
achy126316092achy
acid77533402acid
acme86924322acme
acne66625872acne
acre67330772acre
acted88521742acted
actin74922552actin
actor71116082actor
acute74720362acute
acyl95314292acyl
adit56443662adit
aft66849012a_ft
airt45757792airt
ait38093912a_it
aits46355542aits
alit46155692alit
alt36467962a_lt
alto47831262alto
alts46639902alts
ant37270792a_nt
anta46839582anta
ante46538902ante
anti45536362anti
ants47243472ants
apt57352542a_pt
art38679142a_rt
arts49650262arts
arty77531312arty
ascot76522512ascot
at212393402a__t
ate37059242a_te
aunt46553652aunt
auto47432082auto
batt65053872batt
bitt65545822bitt
bott66548572bott
butt65143742butt
cacti9318642cacti
cant66362032cant
cart66570342cart
cast67159902cast
cat58282342_cat
cate66254602cate
cats66356342cats
catty104520412catty
cot510483222_cot
cut57957662_cut
echt95722902echt
facet106038522facet
fact97142542fac_t
facts107021892facts
matt65752662matt
mitt66145502mitt
mott66648442mott
mutt65739402mutt
nett46643232nett
octet7324062octet
pact86648722pac_t
pacts95125802pacts
putt66937842putt
scat65848372scat
scatt76030092scatt
scot66242612scot
scut65835542scut
sett45949052sett
tacet75840022tacet
tacit76333672tacit
tact67349032tac_t
tacts76524122tacts
watt75545412watt
yacht13417392yacht
yett76434492yett

Search took 2 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter178691298720.560319091.1
2DLD Change Limit29872830.90632971.3
3Display Results83830.0332515.2
 (SQL Overall)178691831.499119206.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.