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 “winnowing” 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
winnowing164336(None) 
windowing1744811windowing
indowing13198082_indowing
widowing1635182wi_dowing
willowing1645322willowing
windrowing1843212windrowing
winning113516552winn__ing
annoying1246543_annoying
besnowing1544123besnowing
billowing1545873billowing
binning103615453binn__ing
cannoning1237323cannoning
connoting12310023connoting
dinning93416553dinn__ing
endowing13178173_endowing
finning113615113finn__ing
ginning93313983ginn__ing
hinnying15124853hinn_ying
ignoring1036483_ignoring
incoming1349863_incoming
ingoing9311023_ingo_ing
ingoting1039863_ingoting
ingrowing1445533_ingrowing
inning73617633_inn__ing
intoning9311123_intoning
invoking1635653_invoking
knowing15287683__knowing
miaowing1434593mi_aowing
minoring11311473mi_noring
misknowing2042823misknowing
pillowing1545493pillowing
pinioning1246863pinioning
pinning103417853pinn__ing
rinning83216743rinn__ing
sinewing1267593si_newing
sinning83918443sinn__ing
snowing113913453__snowing
tinning83117283tinn__ing
twinning12367043twinn__ing
unbowing1436993_unbowing
unknowing17103593unknowing
wallowing1666073wallowing
wanning113816213wann__ing
wantoning1337083wantoning
whinnying19172733whinn_ying
winching17359903wi_nching
wincing133413903wi_n_cing
winding123517913wi_n_ding
windling132212263wi_ndling
wingding1436453wi_ngding
winging123718713wi_n_ging
wining103625053wi_n__ing
winking153317963wi_n_king
winkling16298293wi_nkling
winnings12327583winn__ings
winnow1234593winnow___
winnowed1543473winnow_ed
winnower1444253winnow_er
winnowers1543953winnowers
winnows1334533winnow__s
wintering13412363wintering
wintling12249923wi_ntling
wonning113210793wonn__ing
wowing133915393w___owing

Search took 8 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 Limit148641646.84321721.6
3Display Results64640.0164000.0
 (SQL Overall)178691647.27924548.8
 
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.