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

298 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
floozy2135661(None) 
flooey123910171flooey
floosy12368151floosy
bloody124710172bloody
blooey115110792blooey
bloomy134510112bloomy
blowzy23516672blowzy
boozy194917062_boozy
doozy186813712_doozy
floaty124210942floaty
flocky18468422flocky
flood95215602floo_d
floods104511652floods
flooie93712152flooie
floor84215232floo_r
floors94112352floors
floozie19295462floozie
floppy1654872floppy
flossy12517702flossy
floury12449572floury
footy115820532f_ooty
fozy197017162f__ozy
frouzy21395282frouzy
frowzy24485792frowzy
gloomy12528762gloomy
looby108115622_looby
looey84822912_looey
loony86918962_loony
loopy105316642_loopy
oozy167018132__oozy
snoozy18517232snoozy
woozy204410602_woozy
alkoxy2033343alkoxy
alloy85519973allo_y
aloof83521573aloo_f
aloofly1343623aloofly
blocky17388353blocky
blood85319523bloo_d
bloods94614843bloods
blooie83913193blooie
bloom95918973bloo_m
blooms104613173blooms
bloop96116153bloo_p
bloops106611343bloops
blotty11178343blotty
blousy11459123blousy
blowby16467513blowby
blowsy14579453blowsy
blowy134315323bl_owy
booby125319513_booby
boody115420403_boody
boogy114518323_boogy
boomy125421823_boomy
booty106125913_booty
booze164718913_booze
bronzy20306713bronzy
broody124510083broody
broomy13449953broomy
choosy14459103choosy
cloddy13405233cloddy
cloggy1344873cloggy
cloot76127053cloo_t
cloots85113693cloots
clotty11208263clotty
cloudy12517803cloudy
cloy96623833cl_o_y
cloze165517543cl_oze
colony115417273colony
cooey105828223_cooey
cooky145321363_cooky
cooly105525423_cooly
cozy185823803__cozy
dhooly13457143dhooly
doody105517913_doody
dooly94821803_dooly
doomy116018263_doomy
dozy175920323__dozy
drooly104911073drooly
droopy12458243droopy
felonry13294843felonry
felony123710323felony
fezzy199811453f_ezzy
fizzy199015083f_izzy
flabby1634573flabby
flaggy14415923flaggy
flakey164410513flakey
flaky155715583fl_aky
flamy135217473fl_amy
flappy1654483flappy
flashy15498173flashy
flatly123110213flatly
flavory1644743flavory
flawy145913383fl_awy
flaxy189012293fl_axy
flay106332803fl__ay
flecky18387653flecky
fledgy14414913fledgy
fleecy14266483fleecy
fleshy15406283fleshy
fleury12417353fleury
fley106626853fl__ey
flimsy14345563flimsy
flinty126112493flinty
flippy1654613flippy
flirty12499143flirty
float85928573fl_oat
floats96816253floats
floc95922123fl_o_c
flocci1335023flocci
flock144717423fl_ock
flocks154713533flocks
flocs105519233fl_ocs
floe76129773fl_o_e
floes85528143fl_oes
flog85523893fl_o_g
flogs95919963fl_ogs
flong95815683fl_ong
flongs105010493flongs
flooded12307933flooded
flooder11258463flooder
floodway1842683floodway
floored11268683floored
floorer10248073floorer
floosie10378933floosie
floozies20326953floozies
flop96925453fl_o_p
flops105920143fl_ops
flora85317103fl_ora
florae94713883florae
floral94313813floral
floras94715693floras
floret9321123floret
florid10311453florid
florin9312653florin
floss85118263fl_oss
flota85315643fl_ota
flotas94013003flotas
flouncy1543673flouncy
flour84916453fl_our
flours94414053flours
flout86226203fl_out
flouts94315273flouts
flow105924923fl_o_w
flowed133513763flowed
flower124815503flower
flowery16327783flowery
flown116213993fl_own
flows115822363fl_ows
fluffy14315783fluffy
flukey16459813flukey
fluky154512293fl_uky
flunky16408093flunky
fluor84512773fluo_r
fluors94311373fluors
flurry12397113flurry
flutey125212523flutey
fluty114415643fl_uty
fly97124953fl___y
flyboy17113913flyboy
flyby1676003fl_yby
flyoff1444023flyoff
flyway18134693flyway
foamy135313203f_oamy
fogey125617873f_ogey
foggy136714543f_oggy
fogy115923183f__ogy
foley115222303f_oley
folksy16484983folksy
folky159214713f_olky
folly115022603f_olly
food86830573f_oo_d
foods95924163f_oods
fool75330593f_oo_l
fools86824203f_ools
foot76248013f_oo_t
foots85528283f_oots
footsy12587933footsy
foozle18369203f_oozle
foray115023973f_oray
forby135317673f_orby
forky156119643f_orky
forty114824273f_orty
foxy176517753f__oxy
foy96044263f__o_y
frenzy2135883frenzy
frizzy20555833frizzy
froggy1434493froggy
frosty124710633frosty
frothy15578373frothy
frowsy15498273frowsy
froze174515653f_roze
furzy2010116063f_urzy
fuzzy1929814513f_uzzy
glazy187410983gl_azy
glitzy19404783glitzy
globby1434683globby
gloom87116523gloo_m
glooms96211683glooms
gloppy1454723gloppy
glory96413293gl_ory
glossy10549003glossy
gloze154815983gl_oze
goody105620393_goody
gooey95522863_gooey
goofy124915623_goofy
gooky135818033_gooky
goony95519783_goony
goopy115816623_goopy
goosy96018883_goosy
groovy13375403groovy
groszy19395703groszy
hoody124919723_hoody
hooey114926603_hooey
hooky155220263_hooky
hooly115022223_hooly
hooty115022443_hooty
kloof123812133kloo_f
kloofs13386353kloofs
klutzy2243003klutzy
kolhozy2662423kolhozy
kolkozy2262143kolkozy
kooky114412873_kooky
lazy166423073_l_azy
lezzy16608083_lezzy
loamy105913343_loamy
lobby125113923_lobby
lofty115813303_lofty
loggy105714193_loggy
logy87025783_l_ogy
lolly85120663_lolly
loo38359823_loo__
looed64626133_looed
looeys95110123_looeys
loof78141053_loo_f
loofa85912813_loofa
loofs85623783_loofs
looie55624243_looie
look87333473_loo_k
looks95124863_looks
loom67035053_loo_m
looms75124643_looms
loon47344793_loo_n
looney94712413_looney
loons55731723_loons
loop67835013_loo_p
loops75723963_loops
loos49051123_loo_s
loose56627683_loose
loot46955823_loo_t
loots55431423_loots
loppy125911663_loppy
lorry86315673_lorry
lory75931713_l_ory
lossy85214643_lossy
loury85716753_loury
lousy84617083_lousy
lowly114113333_lowly
moody115017493_moody
moony104818273_moony
moory105115793_moory
nooky124814813_nooky
ology94113113ol_ogy
oology103210253oology
ooze136420603__ooze
phooey14379233phooey
ploidy1237483ploidy
plotty11208853plotty
plotz164617003plotz_
ploy96123603pl_o_y
poofy136213273_poofy
ptooey11346413ptooey
rooky126117623_rooky
roomy107118063_roomy
rooty86423023_rooty
sleazy18267393sleazy
slobby1334803slobby
sloop76118913sloo_p
sloops85513623sloops
sloppy1395303sloppy
sloshy12366623sloshy
slowly1237153slowly
snoopy11449473snoopy
snooty94211513snooty
snooze15439993snooze
sooey84522433_sooey
sooty84924843_sooty
spoofy14498553spoofy
spooky15418093spooky
spoony114111793spoony
swoony12408263swoony
swoopy14487283swoopy
trooz145016153trooz_
ufology14244563ufology
woody125116883_woody
wooly114417673_wooly
zloty17399793zl_oty
zooey173914803_zooey
zooty175415353_zooty

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.360496363.9
2DLD Change Limit1127162984.84323274.0
3Display Results2982980.0963104.2
 (SQL Overall)1786912985.29933721.6
 
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.