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

117 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
moderates1271074(None) 
moderate11710991moderate_
moderated1388141moderated
moderatos1286521moderatos
derates84028882__derates
federates13310142federates
macerates132113562macerates
moderately1643422moderately
moderato1186262moderat_o
moderator12106542moderator
moderators1386642moderators
modernes1138422moder_nes
modulates1238052modulates
operates10515402_operates
tolerates9312112tolerates
acierates11310793acierates
aerates74627483__aerates
ameerates1149043ameerates
asperates11312543asperates
berates94126853__berates
borates94823013bo__rates
cerates95428233__cerates
cocreates132611883cocreates
coderives1547483coderives
conepates13912283conepates
cooperates1469593cooperates
copemates1549483copemates
corelates11314853corelates
coverages1538833coverages
deaerates10313623deaerates
debates103718523__debates
delates83526283__delates
derate74531233__derate_
derated93623503__derated
derats74625063__derat_s
dolerites101410893dolerites
emeerates1149363emeerates
exonerates17107333exonerates
federate12310873federate_
federated1438413federated
foredates13310043foredates
generates10312703generates
hydrates15229403hyd_rates
ideates8313723_ide_ates
immoderate1553333immoderate_
indurates10310693indurates
iodates8312893iod__ates
iodinates1048203iodinates
iterates81317813_iterates
lacerates112413763lacerates
liberates111012933liberates
literates91415643literates
macerate122314073macerate_
macerated142010523macerated
macerater13259523macerater
maceraters14226633maceraters
maderizes2148943maderizes
madrases112610003mad_rases
makebates1744963makebates
maleates103316343male_ates
maturates11311753maturates
mediates112814063med_iates
medicates14312113medicates
meditates1239813meditates
metates92720003m__etates
meterages1248173meterages
migrates111112843m_igrates
misrates101318233m_isrates
moderateness1565283moderateness
moderating1448803moderating
moderation1348643moderation
moderations1448253moderations
moderne1037123moder_ne_
moderner1145523moder_ner
modernest1248113moder_nest
modernise1244733modernise
modernises1344733modernises
modernities1444623modernities
modernizes2244253modernizes
modernness1343523modernness
moderns1037963moder__ns
modester1197483mode_ster
modestest1245003mode_stest
modesties1247473modesties
modistes1138643mod_istes
modulate1138593modulate_
modulated1336713modulated
mofettes1386083mofe_ttes
monerans10310343monera_ns
moorages1139053mo_orages
moperies12313873moper_ies
morales93619403mo__rales
motivates1447073motivates
numerates11199553numerates
odonates947743_odonates
oleates7417833_ole_ates
operate9615733_operate_
operated11512223_operated
orates64328613_o__rates
outrates82421363_outrates
overages12513833_overages
overate10620963_overate_
overawes14511183_overawes
overhates15311933_overhates
overrates12414613_overrates
reoperates1249643reoperates
siderites10410423siderites
sororates9410463sororates
tolerate8312323tolerate_
tolerated1049123tolerated
ulcerates1148843ulcerates
underages11811083underages
underate9918603underate_
underrates11410553underrates
valerates12310533valerates
venerates12312253venerates
yokemates1844193yokemates

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 Limit1486411176.79621871.8
3Display Results1171170.0631857.1
 (SQL Overall)1786911177.03225411.1
 
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.