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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

86 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
antae56828291antae
ante46538901ant_e
anted66328241anted
anteed75616111anteed
antes56334321antes
antre55224521antre
ackee115825372ackee
acted88521732acted
after85719792after
agee56241492a_gee
aglee65728492aglee
agree65226032agree
ajee115928232a_jee
akee85936812a_kee
alee46652322a_lee
allee54932122allee
alter54828502alter
ane37866952an__e
anele55628832anele
anes45255932an_es
anew76623132an_ew
angel65019572angel
anger66225882anger
angle64528882angle
anile54634462anile
anime75423202anime
anise55129712anise
ankle95220252ankle
annex12310882annex
annexe1337812annexe
anode65021042anode
anole55330382anole
ansae55720972ansae
ant37270792ant__
anta46839582ant_a
antas55432032antas
anthem113410342anthem
anther93715062anther
anti45536362ant_i
antic75728862antic
antis55033312antis
antler64615552antler
antra56521922antra
antres65021002antres
ants47243472ant_s
antsy85712792antsy
apter76120202apter
arete56031352arete
artel56122742artel
aster55434892aster
ate37059242a_t_e
ates45047922a_tes
auntie64317702auntie
awee76336642a_wee
banter84825342banter
canted94825782canted
canteen9411082canteen
canter85230112canter
cantle84522152cantle
enter54726382enter
entree61817882entree
grantee83217132grantee
hanted104124312hanted
hantle94318202hantle
inter55028492inter
kantele1138252kantele
knee85323612kn_ee
manatee9317662manatee
mantel84317972mantel
mantes84430782mantes
mantle84420922mantle
mentee84121292mentee
nates55238332nates
nee36657782_n_ee
panted95024822panted
pantie84326472pantie
pattee84323382pattee
ranee55438102ran_ee
ranted74324702ranted
ranter63826822ranter
tee38366872__tee
tutee5423522tutee
undee65327272undee
untie54425492untie
wanted104319722wanted
wanter94423052wanter

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 Filter178691538000.296603685.8
2DLD Change Limit53800861.59333772.8
3Display Results86860.0165375.0
 (SQL Overall)178691861.90593801.0
 
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.