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
moderates1271075(None) 
moderate11710991moderate_
moderated1388141moderated
moderatos1286531moderatos
derates84028892__derates
federates13310152federates
macerates132113572macerates
moderately1643422moderately
moderato1186262moderat_o
moderator12106542moderator
moderators1386642moderators
modernes1138422moder_nes
modulates1238052modulates
operates10515412_operates
tolerates9312122tolerates
acierates11310823acierates
aerates74627503__aerates
ameerates1149073ameerates
asperates11312563asperates
berates94126883__berates
borates94823023bo__rates
cerates95428253__cerates
cocreates132611893cocreates
coderives1547483coderives
conepates13912283conepates
cooperates1469613cooperates
copemates1549483copemates
corelates11314873corelates
coverages1538833coverages
deaerates10313643deaerates
debates103718533__debates
delates83526283__delates
derate74531233__derate_
derated93623503__derated
derats74625063__derat_s
dolerites101410893dolerites
emeerates1149373emeerates
exonerates17107343exonerates
federate12310883federate_
federated1438423federated
foredates13310063foredates
generates10312723generates
hydrates15229413hyd_rates
ideates8313733_ide_ates
immoderate1553333immoderate_
indurates10310693indurates
iodates8312903iod__ates
iodinates1048203iodinates
iterates81317823_iterates
lacerates112413783lacerates
liberates111012953liberates
literates91415653literates
macerate122314073macerate_
macerated142010533macerated
macerater13259523macerater
maceraters14226633maceraters
maderizes2148953maderizes
madrases112610003mad_rases
makebates1744973makebates
maleates103316343male_ates
maturates11311763maturates
mediates112814073med_iates
medicates14312113medicates
meditates1239813meditates
metates92720013m__etates
meterages1248183meterages
migrates111112853m_igrates
misrates101318243m_isrates
moderateness1565283moderateness
moderating1448803moderating
moderation1348653moderation
moderations1448273moderations
moderne1037123moder_ne_
moderner1145523moder_ner
modernest1248113moder_nest
modernise1244733modernise
modernises1344733modernises
modernities1444633modernities
modernizes2244263modernizes
modernness1343523modernness
moderns1037963moder__ns
modester1197483mode_ster
modestest1245003mode_stest
modesties1247473modesties
modistes1138643mod_istes
modulate1138593modulate_
modulated1336713modulated
mofettes1386083mofe_ttes
monerans10310353monera_ns
moorages1139053mo_orages
moperies12313873moper_ies
morales93619403mo__rales
motivates1447073motivates
numerates11199573numerates
odonates947743_odonates
oleates7417833_ole_ates
operate9615733_operate_
operated11512223_operated
orates64328613_o__rates
outrates82421373_outrates
overages12513833_overages
overate10620963_overate_
overawes14511183_overawes
overhates15311943_overhates
overrates12414623_overrates
reoperates1249663reoperates
siderites10410433siderites
sororates9410473sororates
tolerate8312323tolerate_
tolerated1049123tolerated
ulcerates1148853ulcerates
underages11811083underages
underate9918603underate_
underrates11410563underrates
valerates12310543valerates
venerates12312263venerates
yokemates1844193yokemates

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 Filter1786911486410.436409841.7
2DLD Change Limit1486411177.61019532.3
3Display Results1171170.0462543.5
 (SQL Overall)1786911178.09222082.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.