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

112 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
pillowy1531642(None) 
billowy15366901billowy
pillory12247451pillory
pillow113110571pillow_
pillows122610121pillows
willowy16276351willowy
billow114111222billow_
billows123611292billows
pillowed14156382pillowed
sallowy13369342sallowy
tallowy13347632tallowy
willow12369692willow_
willows13299752willows
yellowy16255692yellowy
allow85420663_allow_
allows94517683_allows
alloy85519973_allo_y
apiology1436563apiology
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
pallor8313673pallo_r
pallors9314363pallors
pally105727123pall__y
philology1845293philology
pilaw103913743pi_law_
pilaws11399433pi_laws
pileous9510523pileous
pill65339463pill___
pillage103412603pillage
pillar8314023pill_ar
pillars9313493pillars
pillbox1843413pillbox
pilled94222753pill_ed
pilling103722563pilling
pillion92011703pillion
pillions101610923pillions
pillowing1545493pillowing
pills74130973pill__s
pilose84514243pi_lose
pilot77435063pi_lo_t
pilots84018873pi_lots
pilous84717753pi_lous
pily96132733pi_l__y
plow95923233p__low_
plows105419903p__lows
ploy96123603p__lo_y
pollock1546843pollock
pulley113713403pull_ey
pullout9310593pullout
sallow94315753sallow_
sallowly14344833sallowly
sallows103915553sallows
sillily10209783sillily
silly84527623sill__y
spillway1642763spillway
tallow93714203tallow_
tallows103313743tallows
villose1038053villose
villous102810023villous
wallow123913513wallow_
wallows133613533wallows
willowed15156763willowed
willower14127453willower
willy115321913will__y
windowy1744643windowy
yellow12429883yellow_
yellowly17283623yellowly
yellows13329603yellows

Search took 9 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 Limit1340271128.25016245.7
3Display Results1121120.0462434.8
 (SQL Overall)1786911128.70220534.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.