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

126 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
willowy1627635(None) 
billowy15366901billowy
pillowy15316421pillowy
willow12369691willow_
willows13299751willows
billow114111222billow_
billows123611292billows
pillory12247452pillory
pillow113110572pillow_
pillows122610122pillows
sallowy13369342sallowy
tallowy13347632tallowy
wallow123913512wallow_
wallows133613532wallows
willowed15156762willowed
willower14127452willower
willy115321912will__y
windowy1744642windowy
yellowy16255692yellowy
allow85420663_allow_
allows94517683_allows
alloy85519973_allo_y
bellow114213353bellow_
bellows124313303bellows
billon83713833billo_n
billons93013363billons
billowed14137063billowed
billy105525363bill__y
biology1337363biology
blowy134315323__blowy
callow114714663callow_
dilly94923783dill__y
fallow124713853fallow_
fallows133713973fallows
fellow123712743fellow_
fellowly17264093fellowly
fellows134212433fellows
fillo84319783fillo__
fillos94415083fillo_s
filly114424903fill__y
follow124010353follow_
follows13409923follows
gallows113513513gallows
gilly94321633gill__y
hallow124818323hallow_
hallows134417393hallows
hillo84721653hillo__
hilloa94713033hillo_a
hilloas104413553hilloas
hillock1646693hillock
hillocky2053403hillocky
hilloed113211293hilloed
hilloes103815963hilloes
hillos94618893hillo_s
hilly114422163hill__y
hollow124212663hollow_
hollowly1743383hollowly
hollows134412333hollows
illy76925333_ill__y
killjoy2142343killjoy
killock1255253killock
lollopy12234773lollopy
mallow114014743mallow_
mallows123714323mallows
mellow114112223mellow_
mellowly16254003mellowly
mellows123812233mellows
mildewy16353533mildewy
pillowed14156383pillowed
sallow94315753sallow_
sallowly14344833sallowly
sallows103915553sallows
sillily10209783sillily
silly84527623sill__y
swallow13355753swallow_
swallows14295893swallows
tallow93714203tallow_
tallows103313743tallows
villose1038053villose
villous102810023villous
wallaby1535073wallaby
wallop113310293wallo_p
wallops123410413wallops
wallowed15148163wallowed
wallower14158933wallower
wally114625093wall__y
wellaway1773713wellaway
welly114620013well__y
whitlow1642853whitlow_
whitlows1743083whitlows
wicopy1634033wi_copy
widow1278933wi_dow_
widows1376563wi_dows
wieldy13476183wiel_dy
wilco1039443wilco__
wildfowl1842243wildfowl
wildly13328123wi_ldly
wilily123310763wi_lily
will75737513will___
willed104722453will_ed
willer94021063will_er
willers103517913willers
willet95124833will_et
willets104414323willets
willful1344533willful
willie94116453will_ie
willied114611563willied
willies103920153willies
willing113821613willing
williwau1452723williwau
williwaw1342323williwaw
willowers15166693willowers
willowier1563783willowier
willowing1645323willowing
willpower1773183willpower
wills84528963will__s
willywaw1641943willywaw
wily106428813wi_l__y
window1347363window_
windows1447743windows
winnow1234593winnow_
winnows1334533winnows
witloof1344353witloof
yellow12429883yellow_
yellowly17283623yellowly
yellows13329603yellows

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 Limit1340271266.45320769.7
3Display Results1261260.0462739.1
 (SQL Overall)1786911266.90525878.5
 
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.