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 “anti” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

130 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
anti4553636(None) 
ani37751181an_i
ant37270791ant_
anta46839581anta
ante46538901ante
antic75728861antic
antis55033311antis
ants47243471ants
inti46626081inti
abri65522212abri
act59557842act_
acta69524802acta
actin74922552actin
acts66929862acts
adit56443652adit
aft66849012aft_
ahi68040232a_hi
ai211288392a__i
ait38093902ait_
aits46355532aits
alit46155692alit
alt36467962alt_
alto47831262alto
alts46639902alts
ami56646812a_mi
an211879082an__
ana39559832an_a
anal48037522anal
anas46649862anas
and47244172an_d
ands57833612ands
ane37866952an_e
anes45255932anes
anew76623132anew
anga56831352anga
anil46437432anil
animi74016662animi
anis45746462anis
ankh111114412ankh
anna45529012anna
anoa45634472anoa
anon46134852anon
ansa45927772ansa
antae56828292antae
antas55432032antas
anted66328242anted
antes56334322antes
antiar6317172antiar
antick124814582antick
antics84621452antics
anting75827022anting
antra56521922antra
antre55224522antre
antsy85712792antsy
anus47131112anus
anvil82712602anvil
any68440492an_y
apt57352542apt_
art38679142art_
arts49650262arts
arty77531312arty
asci66519142asci
astir55517092astir
at212393402a_t_
ate37059242a_te
att35454652a_tt
attic75618352attic
aunt46553652aunt_
auntie64317702auntie
aunts55227632aunts
aunty85919812aunty
auto47432082auto
bani65334962ban_i
banty106624002banty
cacti9318642cacti
cant66362032cant_
canthi11310972canthi
cantic103920542cantic
canto74931012canto
cants77036942cants
canty105226802canty
entia5318202entia
hant75461592hant_
hants86335402hants
intis55121642intis
into45026152into
janty156816962janty
kanji1647452kanji
knit85728142knit
lanai5319572lanai
lati46438272lati
loti46431842loti
manta75629912manta
mantic104120902mantic
mantid93820382mantid
mantis83926032mantis
naoi46024632naoi
nazi136219872nazi
nit37065942_nit
nth66320592_nth
ontic74418572ontic
onto46127662onto
pant66061262pant_
pantie84326472pantie
panto76129412panto
pants76536922pants
panty105929302panty
rani46640112ran_i
rant45864682rant_
rants55935342rants
roti46332932roti
santir6315252santir
santo56227282santo
sati45539332sati
senti56226702senti
shanti94014092shanti
snit46342472snit
tanto55724942tanto
ti28448292__ti
titi47130622titi
unai44824782unai
unci65019462unci
unit45140072unit
untie54425492untie
until53517742until
unto45824282unto
want76156172want_
wants87932212wants
yeti75823212yeti
ziti136022372ziti

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.0632836365.1
2DLD Change Limit298721300.93631914.5
3Display Results1301300.0304333.3
 (SQL Overall)1786911301.029173655.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.