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

64 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
wintrily144537(None) 
windily1437942win_dily
winterly14306742winterly
wintrier1136872wintrier
wintry12498922wintr__y
wirily123310782wi__rily
wittily1336172wi_ttily
airily93014823ai__rily
angrily1137723_angrily
daintily1245523daint_ily
dietarily1344453dietarily
dingily1238103din_gily
dirtily1138583dirt_ily
fierily1339023fi_erily
filthily1743663filthily
flintily1434893flint_ily
gentrify1544683gentrify
hungrily1563053hungrily
inertly1038543_inertly
introfy1344753_introfy
kinkily1335223kin_kily
minority1347933minority
mistily122612343mist_ily
niftily1335753nift_ily
ninthly1344213nint_hly
nitrify1335793ni_trify
nitril62511533ni_tril_
nitrile73011373ni_trile
nitrils72810703ni_trils
paltrily1345413paltrily
pintail9311183pintail_
pintails10310163pintails
pithily1567033pi_thily
ritzily1945143ri_tzily
sultrily1146493sultrily
sundrily1246063sundrily
tinily94014433tin__ily
tinnily1047363tin_nily
unitarily1246023unitarily
untruly1046293_untruly
vitrify1645003vi_trify
wantonly1443063wantonly
warily122915093w__arily
waterily1438783waterily
wearily1338783w_earily
wilily123310763wi__lily
windmill14133513windmill
wineries112316533wineries
winery125014283winer__y
wingedly1644013wingedly
winterier1238333winterier
wintering13412363wintering
winterish1546643winterish
winterize2146923winterize
winterkill1752313winterkill
wintery13399753wint_ery
wintle94014603wint__le
wintling12249923wintling
wintriest1238153wintriest
wispily1535653wi_spily
wizardly2452573wizardly
wontedly1544253wontedly
worthily1745253worthily
wrathily1744773wrathily

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 Filter1786911461620.453394461.4
2DLD Change Limit146162646.42022766.7
3Display Results64640.0331939.4
 (SQL Overall)178691646.90625874.7
 
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.