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

68 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
mildewing164373(None) 
mildening1345671mildening
milding113615452mild__ing
moldering1367862moldering
wildering1456742wildering
bedewing1537143_bedewing
billeting1236633billeting
billowing1545873billowing
bitewing1435293bi_tewing
cindering13311223cindering
clewing13359583_cl_ewing
dewing114115703___dewing
diademing1454323diademing
fileting1239303fil_eting
filleting1335843filleting
filtering13199723filtering
gilding103813003gild__ing
hilding123713533hild__ing
hindering14310273hindering
indexing1737123_indexing
indowing13198083_indowing
maddening1445113maddening
melding113414273meld__ing
mellowing1545893mellowing
mewing123914203m___ewing
miaowing1434593mi_aowing
middling13249343mi_ddling
milden94113153milde__n_
mildens10339933milde__ns
mildew12319043mildew___
mildewed1543763mildew_ed
mildews13365883mildew__s
mildewy16353533mildew__y
milking143712763mil__king
milling103223683mil__ling
milting103619123mil__ting
mimeoing1336143mi_meoing
minding113317893mind__ing
misdating131010663misdating
misdealing1457363misdealing
misdeeming1644993misdeeming
misdefine1545513misdefine
misdoing1238803misd_oing
misdrawing1745803misdrawing
mitering113015403mi_tering
modeling12311073m_odeling
modeming1437103m_odeming
molding114213753mold__ing
mouldering1474283mouldering
murdering1357133murdering
niddering1255323niddering
nidering10510483ni_dering
pilfering1536393pilfering
pillowing1545493pillowing
sideling101012183si_deling
silvering1337923silvering
sinewing1267593si_newing
slewing113311353_sl_ewing
smoldering1474103smoldering
soldering1169033soldering
tillering1037883tillering
viewing1437073vi__ewing
widening13237833wi_dening
widowing1635183wi_dowing
wilding123814293wild__ing
wildling13248083wild_ling
willowing1645323willowing
windowing1744813windowing

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 Filter1786911486410.420425454.8
2DLD Change Limit148641686.22023897.3
3Display Results68680.0332060.6
 (SQL Overall)178691686.67326778.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.