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

108 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
winsome123746(None) 
winsomer1345771winsomer
income10712092_income
insole63515862_insole
lissome937582lissome
wagsome1345212wagsome
wailsome1344492wailsome
winsomely1743192winsomely
winsomest1444332winsomest
woesome1246732woesome
anisole71010833anisole
awesome1245573awesome
biome94916993bi__ome
cineole91010003cineole
console92715983console
consomme1445373consomme
consume11510133consume
disme85716243di_s_me
distome10313233distome
episome1157813episome
eyesome1246163eyesome
fulsome1245363fulsome
genome94312193gen_ome
gnome84213953_gn_ome
handsome1447603handsome
hansom11219153hansom_
hansoms12238523hansoms
incomer1169943_incomer
incomes11712373_incomes
indole74516053_indole
inhume1196583_inhume
insane6314893_insane
inshore1038723_inshore
inside7613453_inside
insoles73516243_insoles
insoul638463_insoul
insure63416603_insure
intime81014273_intime
intomb1036403_intomb
intone61115433_intone
invoke1336213_invoke
inwove12167273_inwove
irksome1344373irksome
isomer8310153_i_somer
kinsmen1335653kins_men
kinswomen1852753kinswomen
liposome1246013liposome
lissom837403lissom_
lonesome1047473lonesome
longsome1145933longsome
midsole1037813midsole
misname11119483misname
misnomer1247143misnomer
monosome1299403monosome
noisome947973noisome
nome66038423__n_ome
nonhome1248833nonhome
oinomel946353oin_omel
oxysome1944213oxysome
pinbone1138183pinbone
pinhole122010433pinhole
pinole83218783pin_ole
ransom82410943ransom_
ransomed1146933ransomed
ransomer1047883ransomer
ransoms92410163ransoms
ribosome1245573ribosome
rinse54820973rins__e
rissole739783rissole
sinsyne1043303sinsyne
some66040383___some
tinstone848173tinstone
tiresome1046993tiresome
toilsome1045203toilsome
trisome9310223trisome
twasome1244623twasome
twosome1245303twosome
ugsome934783_ugsome
welcome1445193welcome
whinstone1544273whinstone
wince105220883win__ce
windage1237933windage
windle104617953win_dle
window1347363windo_w
windowed1635573windowed
windows1447743windows
windowy1744643windowy
windsock1843183windsock
wine74953423win___e
winesop1264233wineso_p
winesops1374663winesops
wingmen1336113win_gmen
wingover1544303wingover
winkle133812833win_kle
winnock1643893winnock
winnow1234593winno_w
winnowed1543473winnowed
winnower1444253winnower
winnows1334533winnows
wino75933613win_o__
winoes94317013win_oes
winos84625043win_o_s
wins75949173wins___
wintle94014603win_tle
winze175014853win__ze
wisdom1235983wisdom_
wisdoms1335453wisdoms
wise75737343wi_s__e

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271086.08022043.9
3Display Results1081080.0462347.8
 (SQL Overall)1786911086.53227356.2
 
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.