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 “windy” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

132 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
windy12611810(None) 
lindy96918311lindy
rindy95717391rindy
widdy136112181widdy
wind85533851wind_
winds95425601winds
winey115325431winey
wingy126521031wingy
winy107034321win_y
bandy114824182bandy
bendy115017252bendy
biddy124612692biddy
bind76234512bind_
bindi85617012bindi
binds86627472binds
candy115119822candy
dandy104416702dandy
didy99121512di_dy
dingy105721262dingy
dinky135819372dinky
find87532602find_
finds95424822finds
finny114716752finny
giddy115810202giddy
ginny95314572ginny
handy125520872handy
hind85529752hind_
hinds96721472hinds
hinky155618752hinky
hinny115616672hinny
inby95315662_inby
inky115321582_inky
inly75622212_inly
kiddy144910282kiddy
kind96128562kind_
kindly14358842kindly
kinds106221822kinds
kinky115816382kinky
liney87029632liney
lingy96925142lingy
linky127622382linky
linty87126562linty
liny78141322lin_y
middy124812592middy
mincy125817412mincy
mind75434382mind_
minds85427122minds
mingy115520182mingy
minny104518662minny
minty106323902minty
ninny84514932ninny
pandy115021172pandy
piney105727502piney
pinky145823402pinky
pinny105222062pinny
piny911838352pin_y
randy95022082randy
rind56535602rind_
rinds64826142rinds
sandy94221132sandy
shindy13449322shindy
swingy13489872swingy
tidy86822422ti_dy
tinny85317652tinny
tiny76134632tin_y
twiny116012812twin_y
undy85015162_undy
viny106025952vin_y
waddy135312992waddy
wady115324992w_ady
wand85833882wand_
wands96425482wands
waney115120322waney
wanly115118022wanly
wany106432362wan_y
weedy125115002weedy
weirdy13395462weirdy
wend85330452wend_
wends95822812wends
wenny114412462wenny
whiney155012642whiney
whinny15587492whinny
whiny144915572whin_y
wide85235412wi_de
wieldy13476182wieldy
wifey144913672wifey
wifty144212092wifty
wiggy134510732wiggy
wild85126512wild_
wildly13328122wildly
wilds94818202wilds
willy115321912willy
wily106428812wi_ly
wimpy155911922wimpy
win66456292win__
wince105220882wince
wincey144110382wincey
winch135016662winch
winded114918212winded
winder104025262winder
windily1437942windily
windle104617952windle
window1347362window
windowy1744642windowy
windup1235382windup
windway1745152windway
wine74953422win_e
wined94434182wined
winery125014282winery
wines85546862wines
wing86339222win_g
wings95727242wings
wink116435022win_k
winks125325432winks
wino75933612win_o
winos84625042winos
wins75949172win_s
wintry12498922wintry
winze175014852winze
wiry106422832wi_ry
wispy137210972wispy
withy144813762withy
witney12356842witney
witty114717012witty
wonky154011772wonky
woody125116882woody
wordy126916162wordy
wynd116114462wynd_
wynds126310372wynds
zincy195413512zincy
zingy186516132zingy
zinky215314812zinky

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001321.39038705.0
3Display Results1321320.0304400.0
 (SQL Overall)1786911321.716104132.3
 
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.