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 “moderating” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

74 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
moderating144880(None) 
derating103222282__derating
federating1548852federating
macerating1549542macerating
moderation1348652moderation
moderations1448272moderations
modulating1446372modulating
operating12313722_operating
tolerating1148592tolerating
acierating1348323acierating
aerating92821003__aerating
asperating1349563asperating
berating113220763__berating
borating113414503bo__rating
cocreating15310293cocreating
coderiving1744993coderiving
cooperating1648423cooperating
corelating13511583corelating
deaerating12311563deaerating
debating123213733__debating
delating103119603__delating
deratting1139513__deratting
exonerating1945553exonerating
foredating1577123foredating
generating12310393generating
hydrating1746323hyd_rating
ideating10311703_ide_ating
indurating1249243indurating
iodating1038823iod__ating
iodinating1246963iodinating
iterating10314253_iterating
lacerating1349453lacerating
liberating1349253liberating
maderizing2346463maderizing
maturating13108573maturating
medevacing1942863medevacing
mediating13311203med_iating
medicating1648953medicating
meditating1448123meditating
meriting11314693m__eriting
migrating13910533m_igrating
miseating121215433mise_ating
misrating121014853m_israting
moating104218153mo___ating
modeling12311073mode__ling
modelling1336883mode_lling
modeming1437103mode__ming
moderate11710993moderat__e
moderated1388143moderat_ed
moderately1643423moderately
moderates12710753moderat_es
moderato1186263moderat__o
moderator12106543moderat_or
moderators1386643moderators
moderatos1286523moderat_os
modernising1543753modernising
modernizing2444103modernizing
moldering1367863molder__ing
molesting1237753mole_sting
motivating1646803motivating
numerating1357233numerating
orating83520323_o__rating
outrating10916403_outrating
overacting16310913_overacting
overawing16710293_overawing
overeating141016533_overeating
overhating17910953_overhating
overrating14814203_overrating
reoperating1449023reoperating
ulcerating1346983ulcerating
underacting1547523underacting
undereating1369553undereating
underrating1388253underrating
venerating14410053venerating

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 Filter1786911406030.406440125.6
2DLD Change Limit140603745.64024929.6
3Display Results74740.0461608.7
 (SQL Overall)178691746.09229332.1
 
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.