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

47 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
windthrows205156(None) 
windthrow1951421windthrow_
windrows1546162wind__rows
misthrows17114213mi_sthrows
windows1447743wind___ows
windrow1445853wind__row_
cinderous1247044cind_erous
downthrows2051704downthrows
indows104210794_ind___ows
inthrals11258504_in_thrals
inthrone1179474_in_throne
inthrones1299674_in_thrones
introns73515024_in_t_rons
intros64215774_in_t_ro_s
misthrow16134274mi_sthrow_
misthrown1793134mi_sthrown
outthrows15123694_outthrows
overthrows1943414overthrows
throws129715234____throws
upthrows1643304__upthrows
wanderoos1345554wand_eroos
widows1376564wi_d___ows
widths1335124wi_dth___s
widthways2251794wi_dthways
windblown1851794wind_blown
windburns1542214windbur_ns
windchills1951774windchills
winders113721264wind_er__s
windflaws1942404wind_flaws
windigos13484904wind_igo_s
window1347364wind___ow_
windowy1744644wind___owy
windproof1852734wind_proof
windrowed1743724wind__rowed
windrower1644234wind__rower
windrowers1743844wind__rowers
windstorms1651944windstor_ms
windsurfs1641914windsur_fs
windwards1764514windwar_ds
wineshops1743964winesh_ops
wingbows1743984win__gbows
winnows1334534win___nows
winterers12209724win_terers
winters103720484win_ter__s
withdraws1942984wi__thdraws
witherods16145444wi__therods
wondrous1246824wond__rous

Search took 10 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 Filter1786911614500.436409841.7
2DLD Change Limit161450479.39317188.3
3Display Results47470.0301566.7
 (SQL Overall)178691479.85918124.7
 
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.