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

143 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
simulate1031113(None) 
simulated1238281simulated
simulates1139841simulates
stimulate1148231stimulate
cumulate123110222cumulate
emulate9314122_emulate
hamulate1359012hamulate
ligulate92510242ligulate
sibilate1049532sibilate
simulacre1342612simulacre
simulant1048082simulant
simulants1144992simulants
simular938672simula_r
simulars1047072simulars
simulative1545262simulative
simulator1146712simulator
sinuate7412152sinu_ate
situate7410772situ_ate
spiculate132210162spiculate
stimulated1346362stimulated
stimulates1247382stimulates
stipulate1147322stipulate
subulate10312742subulate
aciculate132510803aciculate
acidulate12256893acidulate
adulate8313233_adulate
ambulate1239733ambulate
angulate9312013angulate
annulate8310923annulate
apiculate13279883apiculate
assimilate1254493assimilate
bijugate1843513bijugate
bisulcate13144063bisulcate
bisulfate14143653bisulfate
canulate10314553canulate
cingulate12238583cingulate
circulate13810433circulate
copulate122614113copulate
cumulated14237843cumulated
cumulates13258963cumulates
cupulate122810033cupulate
dilate73220693di__late
dissimulate14114973dissimulate
disulfate13145713disulfate
divulgate1463103divulgate
emulated11310793_emulated
emulates10312573_emulates
fabulate1339203fabulate
fibulae12237013fibula_e
figurate1237183figurate
fistulate1246453fistulate
formulate1446993formulate
imamate1138093_imamate
imblaze2044323_imblaze
imitate9310873_imitate
immolate1246543immolate
inflate10312313_inflate
insulate8312843insulate
inulase739413_inulase
isolate7313923_isolate
jaculate172311783jaculate
jugulate1645483jugulate
ligulae8308753ligula_e
ligulated11247353ligulated
limbate1139213lim_bate
lingulate10368183lingulate
liquate1638413liqu_ate
lobulate1078833lobulate
loculate101011403loculate
lunulate838253lunulate
maculate122815623maculate
malate84624553__malate
modulate1138593modulate
mutate83017483__mutate
osculate101010613osculate
ovulate1039453_ovulate
peculate122414663peculate
pinnulate1145763pinnulate
populate122812093populate
regulate9313023regulate
restimulate1365843restimulate
rosulate8310903rosulate
sacculate1349023sacculate
saturate8312813saturate
scopulate1366543scopulate
scutate9310323s_cutate
serrulate946983serrulate
sibilated1246713sibilated
sibilates1148443sibilates
sigmate10710123si_gmate
silage72715303si__lage
silane62718053si__lane
silicate10312623silicate
similar937853simila_r
simile83115633simil__e
simple104315173simpl__e
simulacra1352023simulacra
simulacres1452533simulacres
simulating1347613simulating
simulation1269583simulation
simulators1246083simulators
simulcast1372343simulcast
simulcasted1651203simulcasted
simulcasts1471613simulcasts
sinuated938403sinu_ated
sinuates8310953sinu_ates
situated938023situ_ated
situates8310363situ_ates
slate55438283s___late
solate64526073s__olate
soulmate1047183s_oulmate
spatulate11107173spatulate
speculate13239183speculate
spiculae12218603spicula_e
spinulae10276963spinula_e
spirulae10216573spirula_e
sporulate1146953sporulate
stellate8310503stellate
stimulant1145163stimulant
stimulants1253373stimulants
stimulative1653973stimulative
stimulator1245293stimulator
stipulated1345593stipulated
stipulates1256683stipulates
stridulate1144993stridulate
stylate10179773s_tylate
sublate9315363s_ublate
sufflate1456183sufflate
sulcate9314423s__ulcate
sulfate10311653s__ulfate
summate113611663sum_mate
tabulate10310893tabulate
template1238433template
tinplate1047733tinplate
tribulate1148083tribulate
tubulate1038273tubulate
ululate749963_ululate
undulate9310403undulate
ungulate939803ungulate
ustulate868323ustulate
vesiculate1547223vesiculate
violate10311553vi_olate
virgulate1345233virgulate

Search took 9 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.1701051123.5
2DLD Change Limit1461621437.95318378.2
3Display Results1431430.0463108.7
 (SQL Overall)1786911438.16921874.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.