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

144 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
billowy1536690(None) 
billow114111221billow_
billows123611291billows
pillowy15316421pillowy
willowy16276351willowy
bellow114213352bellow_
bellows124313302bellows
billon83713832billo_n
billons93013362billons
billowed14137062billowed
billy105525362bill__y
biology1337362biology
blowy134315322b__lowy
pillory12247452pillory
pillow113110572pillow_
pillows122610122pillows
sallowy13369342sallowy
tallowy13347632tallowy
willow12369692willow_
willows13299752willows
yellowy16255692yellowy
allow85420663_allow_
allows94517683_allows
alloy85519973_allo_y
balcony1435853balcony
ballon84117493ballo_n
ballons93916963ballons
balloon93711433balloon
ballot84624093ballo_t
ballots94116033ballots
ballsy11508873ball_sy
bally105530103ball__y
barlow112911423barlow_
barlows12259973barlows
beclown1435423beclown
bellboy1445123bellboy
bellowed14158603bellowed
bellower13159063bellower
belly104625493bell__y
below104617193b_elow_
belows114614183b_elows
bialy105119323bial__y
bigly114814753bigl__y
bilbo95513613bilbo__
bilboa10367843bilbo_a
bilboas11438733bilboas
bilboes114410243bilboes
bilbos105011203bilbo_s
bilby124912353bi_l_by
bilgy114713713bi_l_gy
biliary1238213biliary
bilious9310933bilious
bill67239943bill___
billbug1242753billbug
billed94224903bill_ed
biller84923483bill_er
billers94720833billers
billet86029723bill_et
billets94516153billets
billfold1443153billfold
billhook1743653billhook
billie85019173bill_ie
billies93923503billies
billing103823853billing
billion92212173billion
billions102211793billions
billowier1444293billowier
billowing1545873billowing
bills75632863bill__s
biltong1034683biltong
bionomy1444723bionomy
bloody124710173b_loody
blooey115110793b_looey
bloomy134510113b_loomy
blow95827193b__low_
blowby16467513b__lowby
blown105716673b__lown
blows105423833b__lows
blowsy14579453b__lowsy
blowzy23516673b__lowzy
bollox1548743bollo_x
brillo84211003brillo__
brillos9369183brillo_s
bullock1537193bullock
bullocky1943643bullocky
bullous9311663bullous
bully105124813bull__y
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
tallow93714203tallow_
tallows103313743tallows
villose1038053villose
villous102810023villous
wallow123913513wallow_
wallows133613533wallows
willowed15156763willowed
willower14127453willower
willy115321913will__y
windowy1744643windowy
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.403443402.0
2DLD Change Limit1340271446.48620664.0
3Display Results1441440.0463130.4
 (SQL Overall)1786911446.93525766.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.