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 “anteater” 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.

150 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
anteater831160(None) 
anteaters939341anteaters
animater101512392animater
annealer845502annealer
antedate949682antedate_
antedated1146702antedated
antedates1048612antedates
attester836502attester
neater64424312_n_eater
abater85518123a__bater
abetter958323a_better
absenter1086773absenter
accepter14144933accepter
acetate92514753acetate_
acetated112010683acetated
acetates102013063acetates
actuate9311443actuate_
actuated1138743actuated
actuates10310313actuates
actuator1046643actuator
adepter1036113a_depter
affecter1644523affecter
alerter72111513a_lerter
alterer72713993alte_rer
ammeter1148393amme_ter
ancestor1046853ancestor
ancienter1145393ancienter
anear55420323an_ea__r
aneared8512743an_eared
animate91617213animate_
animated111612373animated
animaters11129973animaters
animates101316423animates
animator101410293animator
annates72415423an_nates
annealed936333annealed
annealers944563annealers
anointer837823anointer
ansate64517863an_sate_
ansated84214003an_sated
antae56828293ant_a_e_
antbear935063antbea__r
anteed75616113ante__ed
antenatal964773antenatal
anterior8611053anterior
antevert1148993ante_vert
anther93715063ant__her
antiair7310313antia_ir
antiar6317173antia__r
antiatom1048463antiatom
antimatter1245303antimatter
antiquer1746873antiquer
antler64615553ant__ler
antsier7410773ant_sier
appealer1245743appealer
appeaser1245953appeaser
arrester839253arrester
assenter867703assenter
asserter877573asserter
atelier7311623a_telier
attemper12103633attemper
attempter1342963attempter
attender935913attender
attested936293attested
attesters935803attesters
attestor845463attestor
attracter1146093attracter
aureate72515283aureate_
averter102410553a_verter
aweather1434263a_weather
banterer102811773bante_rer
beater84729393__beater
bleater94515303_bleater
castrater1148523castrater
cheater124816963_cheater
contester11311183contester
cutwater1344833cutwater
defeater122611663defeater
detecter11298733detecter
detester9239683detester
eater54639843___eater
enfetter1145353enfetter
entente7412953entente_
ententes8312773ententes
enterer72015633ente_rer
entreated10310973entreated
feater95224053__feater
figeater1236953figeater
greater84416493_greater
heater94828303__heater
incenter102212093incenter
indenter92311443indenter
infecter13229153infecter
infester11239433infester
inflater1149893inflater
inserter82312133inserter
insetter8218593insetter
integer837993inte_ger
intender93310443intender
intenser8199443intenser
interterm1148813interterm
intimater111110583intimater
intreated10312663intreated
inventer112410843inventer
inverter112411073inverter
kneader1275893kn_eader
maltreater12124743maltreater
narrater838723narrater
natter64420743nat__ter
nearer64618893_n_earer
neaten64214543_n_eaten
negater83711963_negater
nester64124183_n_ester
netter63722023_n_etter
neuter63713793_n_euter
outeaten8310423outeaten
pleater93916333_pleater
reheater113413033reheater
repeater102615443repeater
retreater9310203retreater
saltwater1244353saltwater
seater64534153__seater
sneaker112910453sn_eaker
stater64427563_st_ater
stealer72913973_stealer
steamer93313093_steamer
sweater103712723_sweater
tater54138613__t_ater
tearer64822903__tearer
teaser65421523__teaser
teated74924023__teated
teeter65420313__teeter
tenter64623933__tenter
tester64227153__tester
tetter64322453__tetter
theater104014253_theater
treater74219833_treater
unbeaten1038013unbeaten
uneager839753un_eager
uneaten7412543un_eaten
unfetter1136753unfetter
unheated121514553unheated
unseated91317683unseated
untented92613413untented
untested92612413untested
untether1145163untether
untreated10312903untreated
wastewater16143003wastewater
xanthate1845713xanthate_
xanthates1945653xanthates

Search took 7 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 Filter1786911461620.1531167915.0
2DLD Change Limit1461621506.36022981.4
3Display Results1501500.0632381.0
 (SQL Overall)1786911506.57627173.2
 
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.