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

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

200 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
winnow123459(None) 
minnow1135581minnow
window1347361window
winnows1334531winnows
indow95011662_indow
minnows1234912minnows
widow1278942wi_dow
willow12369692willow
windows1447742windows
windowy1744642windowy
windrow1445852windrow
wingbow1643772wingbow
winned104017012winned
winner94219932winner
winnock1643892winnock
winnowed1543472winnowed
winnower1444252winnower
wino75933622wi_no_
winos84625042wi_nos
annoy869713_annoy
besnow1145713besnow
billow114111223billow
bingo86020093bingo_
bingos95514793bingos
binned94414543binned
cannon84514443cannon
cannot83616773cannot
cineol8108203cineol
dingo74720793dingo_
dinned84317613dinned
dinner74217163dinner
dino56036763di_no_
dinos65428063di_nos
endow94510983_endow
enow77819873__enow
erenow937373erenow
finned104114603finned
finny114716753finn_y
fino76034703fi_no_
finos86226953fi_nos
ginned83813983ginned
ginner73915823ginner
ginny95314573ginn_y
ginzo1539613ginzo_
hinny115616673hinn_y
incog838253_incog
indol63714873_indol
indows104210793_indows
inflow1235293_inflow
info75617353_info_
infos84311673_infos
ingot61221063_ingot
inion54620183_inion
inn36727443_inn__
inned64118423_inned
inner54920633_inner
inns46920933_inn_s
inro45920793_inro_
into45026153_into_
intown936153_intown
jingo134615213jingo_
jinn115420253jinn__
jinnee13411573jinnee
jinni125310633jinn_i
jinnis13489053jinnis
jinns126013843jinn_s
kino86233633ki_no_
kinos96626153ki_nos
know116115853__know
lingo66022113lingo_
linn46034603linn__
linnet6419423linnet
linns56123333linn_s
lino46343383li_no_
linos55631503li_nos
lintol6369473lintol
miaow1058353mi_aow
mignon937953mignon
minion83416243minion
minny104518663minn_y
minor74920063mi_nor
misknow1643213misknow
ninny84514933ninn_y
ninon55517383ni_non
ninons64913773ninons
now65950193___now
pennon8310643pennon
piano76118713piano_
pianos84315933pianos
pillow113110573pillow
pingo87122713pingo_
pingos95317673pingos
pinion83815893pinion
pinko115618253pinko_
pinkos125313873pinkos
pinna75320183pinn_a
pinnae84414643pinnae
pinnal84814283pinnal
pinnas85315523pinnas
pinned94818383pinned
pinner84521503pinner
pinny105222063pinn_y
pinon76024533pi_non
pinons86019943pinons
pinot78737293pi_not
pinto75625753pinto_
pintos86021293pintos
pinyon11459763pinyon
rainbow1243353rainbow
sannop837373sannop
signor73510353signor
sinew84718923si_new
sinned73818413sinned
sinner64320603sinner
snow76324793__snow
sunbow1145823sunbow
swinney13365973swinney
tannoy958363tannoy
tinned74317533tinned
tinner64119963tinner
tinny85317653tinn_y
tinpot8312513tinpot
twinned11366333twinned
vino76128443vi_no_
vinos84723073vi_nos
wallow123913513wallow
wanion93213063wanion
wanned104318013wanned
wanner94019623wanner
wanton94413813wanton
wenny114412463wenn_y
whinny15587493whinn_y
whitlow1642863whitlow
widows1376563wi_dows
wiener94513543wiener
wienie9229973wienie
wigeon1037223wigeon
wilco1039443wilco_
willows13299753willows
willowy16276353willowy
win66456303wi_n__
wince105220883wi_nce
winced124415343winced
wincer115018193wincer
winces114819113winces
wincey144110383wincey
winch135016663wi_nch
wind85533863wi_n_d
winded114918213winded
winder104025263winder
windle104617953windle
windowed1635573windowed
windrows1546163windrows
winds95425613wi_nds
windup1235383windup
windy126118113wi_ndy
wine74953433wi_n_e
wined94434183wi_ned
winery125014283winery
wines85546863wi_nes
winesop1264233winesop
winey115325433wi_ney
wing86339233wi_n_g
wingbows1743983wingbows
winged114620833winged
winger104125443winger
wings95727243wi_ngs
wingy126521033wi_ngy
winier94522453winier
wining103625053wining
winish124212273winish
wink116435033wi_n_k
winked144018603winked
winker134220293winker
winkle133812833winkle
winks125325433wi_nks
winners104316913winners
winning113516553winning
winnocks1743873winnocks
winnowers1543953winnowers
winnowing1643363winnowing
winoes94317013winoes
wins75949183wi_n_s
winsome1237463winsome
winter94222803winter
wintle94014603wintle
wintry12498923wintry
winy107034333wi_n_y
winze175014853wi_nze
winzes184313053winzes
wisdom1235983wisdom
witney12356843witney
wittol935923wittol
wonned104012063wonned
wonner95114443wonner
wonton93410963wonton
wow96643473w___ow
wynn105811293wynn__
wynns11517473wynn_s
zinnia1536013zinnia

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127162005.42020796.3
3Display Results2002000.0633174.6
 (SQL Overall)1786912005.85930498.5
 
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.