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

112 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
simulates113984(None) 
simulate10311131simulate_
simulated1238281simulated
stimulates1247381stimulates
cumulates13258962cumulates
emulates10312572_emulates
sibilates1148442sibilates
simulacres1452532simulacres
simulants1144992simulants
simulars1047072simula_rs
simulator1146712simulator
simulators1246082simulators
sinuates8310952sinu_ates
situates8310362situ_ates
stimulate1148232stimulate_
stimulated1346362stimulated
stipulates1256682stipulates
acidulates13215833acidulates
adulates9311913_adulates
ambulates1348383ambulates
angulates10310853angulates
assimilates1354413assimilates
bisulfates15143223bisulfates
canulates11312863canulates
circulates1489273circulates
copulates132612453copulates
cumulate123110223cumulate_
cumulated14237843cumulated
dilates83220653di__lates
dissimulates15124723dissimulates
disulfates14145363disulfates
divulgates1562933divulgates
emulate9314123_emulate_
emulated11310793_emulated
fabulates1447733fabulates
formulates1546543formulates
hamulate1359013hamulate_
imamates1237653_imamates
imblazes2144723_imblazes
imitates10310503_imitates
immolates1346453immolates
inflates11512193_inflates
insulates9311843insulates
inulases838763_inulases
isolates8613513_isolates
jaculates182810363jaculates
jugulates1744593jugulates
ligulate92510243ligulate_
ligulated11247353ligulated
liquates1737443liqu_ates
maculates132013723maculates
malates93522603__malates
modulates1238053modulates
mutates92215793__mutates
osculates11109393osculates
ovulates1148523_ovulates
peculates132112533peculates
populates132710673populates
regulates101211703regulates
restimulates1465313restimulates
saturates9811593saturates
sibilate1049533sibilate_
sibilated1246713sibilated
silages82514443si__lages
silanes72517163si__lanes
silicates11311523silicates
similes92915233simil__es
simples113014943simpl__es
simplexes2043983simplexes
simplices1546043simplices
simulacra1352023simulacra
simulacre1342613simulacre
simulant1048083simula_nt
simular938673simula__r
simulating1347613simulating
simulation1269583simulation
simulations1368393simulations
simulative1545263simulative
simulcasted1651203simulcasted
simulcasts1471613simulcasts
sinuate7412153sinu_ate_
sinuated938403sinu_ated
situate7410773situ_ate_
situated938023situ_ated
slates64934063s___lates
smilaxes1744653s_milaxes
solates73523853s__olates
soulmates1147073s_oulmates
speculates14237903speculates
spiculate132210163spiculate_
sporulates1246483sporulates
stimulants1253373stimulants
stimulator1245293stimulator
stimulators1344643stimulators
stipulate1147323stipulate_
stipulated1345593stipulated
stridulates1254543stridulates
sublates10315003s_ublates
subulate10312743subulate_
sufflates1546023sufflates
sulfates11310793s__ulfates
summates122610483sum_mates
tabulates1139143tabulates
templates1348263templates
tinplates1147763tinplates
tribulates1247193tribulates
tubulates1147233tubulates
ululates848433_ululates
undulates1048923undulates
ungulates1048343ungulates
vesiculates1646283vesiculates
violates11311183vi_olates

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.1731032896.0
2DLD Change Limit1486411127.15620771.5
3Display Results1121120.0462434.8
 (SQL Overall)1786911127.37524229.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.