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

103 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
estimates1191136(None) 
estimate10912001estimate_
estimated12109441estimated
estivates12109751estivates
aestivates13107362aestivates
estates74520182est__ates
estimator1147422estimator
estimators1247022estimators
estivate111010002estivate_
estivated13108322estivated
festinates1348942festinates
intimates111013312intimates
ostomates1149342ostomates
reestimates1346352reestimates
stomates10313342_stomates
ultimates1148432ultimates
activates1449683activates
aestivate12127663aestivate_
aestivated14106293aestivated
animates101316423_animates
aspirates1139613aspirates
automates11412053automates
busticates1456613busticates
castigates1347553castigates
climates12311973_climates
decimates14410693decimates
despumates1543543despumates
destitutes1156523destitutes
emirates101214853e_mirates
epilates10313503e_pilates
escalates1148823escalates
estate64719763est__ate_
estated83715573est__ated
esterases949633esterases
esthetes1147743est_hetes
estimable1346043estimable
estimably1644383estimably
estimating1348883estimating
estimation12410843estimation
estimations1349943estimations
estimative1546483estimative
estivator1246293estivator
estivators1345923estivators
estreated1039563estreated
estreats839423estreat_s
etiolates949213e_tiolates
expiates17810213expi_ates
extirpates1943683extirpates
extricates1998243extricates
extubates1844843extubates
festinate1249473festinate_
festinated1447533festinated
fustigates1445143fustigates
gestates93213733gest__ates
guesstimates1561933guesstimates
hesitates1269793hes_itates
instigates1148423instigates
intimate101013833intimate_
intimated121010893intimated
intimater111110583intimater
intimaters1297853intimaters
legitimates1454023legitimates
litigates1048003litigates
masticates1449843masticates
messmates1346233mes_smates
misestimates1663563misestimates
mitigates1248253mitigates
motivates1447073motivates
mutilates11310953mutilates
ostinatos946173ostinatos
ostomate1049573ostomate_
patinates113814693patinates
primates121515933_primates
reanimates1247853reanimates
reestimate1246513reestimate_
reestimated1445953reestimated
resinates9314763res_inates
resituates1047753resituates
restates83423433rest__ates
restimulates1465313restimulates
restitutes1057833restitutes
rusticates1248053rusticates
satiates8314633sati_ates
seatmates1157823seatmates
seriates82620673seri_ates
shipmates1645953_shipmates
situates8310373_situates
states64337083_st__ates
stimes85920573_stim__es
stimies9316563_stim_ies
stimulates1247383_stimulates
stipites1039653_stipites
stomate9313123_stomate_
striates83417083_striates
summates122610493_summates
testates83615453test__ates
titivates1246433titivates
ultimate1049203ultimate_
ultimated1247313ultimated
urticates1148893urticates
ventilates1347603ventilates
vesicates14119033ves_icates
vitiates112311433viti_ates

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411036.28023668.9
3Display Results1031030.0462239.1
 (SQL Overall)1786911036.74926476.7
 
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.