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

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

110 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
anteaters93935(None) 
anteater8311601anteater_
animaters11129972animaters
annealers944562annealers
antedates1048612antedate_s
attesters935812attesters
abaters95115203a__baters
abetters1057173a_betters
absenters1156183absenters
accepters15114623accepters
acetates102013063acetate_s
actuates10310313actuate_s
actuators1146443actuators
affecters1763933affecters
alterers82512503alte_rers
ammeters1237693amme_ters
ancestors1147233ancestors
anears63717183an_ea__rs
animater101512393animater_
animates101316423animate_s
animators111210423animators
annates72415423an_nate_s
annealer845503annealer_
anointers937013anointers
antbears1044963antbea__rs
antedate949693antedate__
antedated1146703antedate_d
antevert1148993ante_vert
anteverts1244733ante_verts
anthers103715203ant__hers
antiars7314623antia__rs
antiatoms1147763antiatoms
antimatters1354333antimatters
antiquers1845793antiquers
antlers74014743ant__lers
appealers1345063appealers
appeasers1345263appeasers
arresters948203arresters
assenters967003assenters
asserters956403asserters
ateliers837893a_teliers
attempers13103503attempers
attempters1442663attempters
attenders1045283attenders
attester836503attester_
attestors945753attestors
attracters1245123attracters
averters11249513a_verters
banterers112410013bante_rers
beaters94925043__beaters
bleaters103412323_bleaters
castraters1246483castraters
cheaters133613513_cheaters
contesters12410193contesters
cutwaters1443613cutwaters
defeaters13289103defeaters
detecters12217753detecters
detesters10298303detesters
eaters65535953___eaters
enfetters1244463enfetters
ententes8312773entente_s
enterers82214153ente_rers
figeaters1345753figeaters
heaters104225223__heaters
incenters112510303incenters
indenters102710033indenters
infecters14257583infecters
infesters12237713infesters
inflaters1247543inflaters
inserters92210283inserters
insetters9187133insetters
integers937783inte_gers
intenders10219373intenders
interterm1148813interterm
intimaters1297853intimaters
inventers12269533inventers
inverters12239753inverters
kneaders1384713kn_eaders
maltreaters13133783maltreaters
narraters946703narraters
natters73718063nat__ters
neatens73310403_n_eatens
neater64424313_n_eater_
negaters9349783_negaters
nesters74422793_n_esters
netters73618583_n_etters
neuters74212273_n_euters
pleaters103613793_pleaters
reheaters122010273reheaters
repeaters112811993repeaters
retreaters1047553retreaters
seaters74028943__seaters
sneakers12308643sn_eakers
staters73922343_st_aters
stealers83412213_stealers
steamers103410873_steamers
sweaters113811063_sweaters
taters64932203__t_aters
tearers75218233__tearers
teasers75317243__teasers
teeters74018303__teeters
tenters73921113__tenters
testers74124543__testers
tetters74320473__tetters
theaters114211903_theaters
treaters83615853_treaters
unfetters1244363unfetters
untethers1244153untethers
wastewaters17142513wastewaters
xanthates1945653xanthate_s

Search took 8 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 Filter1786911486410.450397091.1
2DLD Change Limit1486411106.51622811.7
3Display Results1101100.0631746.0
 (SQL Overall)1786911107.02925422.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.