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

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

84 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
willingness155304(None) 
liltingness1253042liltingness
unwillingness1761982unwillingness
willingest1454312willing_est
willingnesses1753172willingnesses
bindingness1553203bindingness
darlingness1373263darlingness
feelingness1553483feelingness
fittingness1553173fittingness
hilliness1248923hilli__ness
livingness1443343li_vingness
silliness9510363silli__ness
wiliness1139113wi_li__ness
willfulness1753513willfulness
willinger1343723willing_e_r
amusingness1452524amusingness
billings113412634billing___s
blindness1235344__blindness
boringness1344674_boringness
bullishness1643954bullishness
chilliness1555314chilli__ness
cunningness1452934cunningness
daringness1244744_daringness
dollishness1544014dollishness
fillings122910504filling___s
filminess1435984filmi__ness
girlishness1573654girlishness
glaringness1343264glaringness
hellishness1744114hellishness
hillinesses1458504hillinesses
illness736474_ill___ness
jolliness1636214jolli__ness
killings133710484killing___s
knowingness1952174knowingness
lastingness1244004lastingness
liltingnesses1453574liltingnesses
longness938554___longness
lovingness1443184_lovingness
milkiness1536524milki__ness
milliners11289954milli__ners
millines102718064milli__ne_s
millings113712584milling___s
nothingness1552924nothingness
obligingness1661774obligingness
oiliness8311564oi_li__ness
ongoingness1373044ongoingness
pallidness1343284palli_dness
plainness1155184_plain_ness
silentness1044574si_lentness
silkiness1337254silki__ness
sillinesses1169844sillinesses
sterlingness1383384sterlingness
sullenness1054154sullen_ness
sweepingness1852204sweepingness
teemingness1453164teemingness
thingness1354894__thingness
thinkingness2051774thinkingness
twillings13234914twilling___s
unwillingnesses1961874unwillingnesses
villainess1343854vill_ainess
wellness1135794well___ness
whininess1535124w__hininess
wifeliness1644484wifeli__ness
wilderness1443514wi_lderness
wildings13287934wilding___s
wildlings14244924wildling___s
wildness1236204wi_l__dness
wilinesses131911094wi_linesses
willies103920154willi___e_s
willing113821614willing____
willingly1645404willing__ly
wimpiness1635294wimpi__ness
wimpishness2143214wimpishness
windiness1337374windi__ness
wingless122910024w___ingless
wiriness1138954wi_ri__ness
wispiness1435634wispi__ness
witlessness1446264witlessness
witlings12328444witling___s
wittiness12197224witti__ness
wolfishness2043734wolfishness
wooliness12147694wooli__ness
woolliness1343564woolli__ness
wrongness1344514w__rongness

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 Filter1786911488190.453394461.4
2DLD Change Limit148819848.00018602.4
3Display Results84840.0461826.1
 (SQL Overall)178691848.49921024.9
 
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.