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

281 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
floppy165487(None) 
flappy1654481flappy
flippy1654611flippy
gloppy1454721gloppy
loppy125911661_loppy
sloppy1395301sloppy
choppy18376292choppy
floaty124210942floaty
flocky18468422flocky
flooey123910172flooey
floosy12368152floosy
floozy21356612floozy
flop96925452flo_p_
flopped15338762flopped
flopper14328472flopper
floppily1843772floppily
flops105920142flo_ps
flossy12517702flossy
floury12449572floury
hoppy154912352_hoppy
jaloppy21302482jaloppy
lippy124511902_lippy
loopy105316642_loopy
poppy114813192_poppy
slippy1375842slippy
soppy125113522_soppy
atopy106813393ato_py
biopsy1334533biopsy
blocky17388353blocky
bloody124710173bloody
blooey115110793blooey
bloomy134510113bloomy
bloop96116153bloop_
bloops106611343bloops
blotty11178343blotty
blousy11459123blousy
blowby16467513blowby
blowsy14579453blowsy
blowy134315323blo_wy
blowzy23516673blowzy
buppy144810073_buppy
chippy18437613chippy
cloddy13405233cloddy
cloggy1344873cloggy
clomp115615703clomp_
clomps125212233clomps
clop86929893clo_p_
clopped143611523clopped
clops95924853clo_ps
clotty11208263clotty
cloudy12517803cloudy
cloy96623833clo__y
clumpy15409573clumpy
copay126516313_copay
copy116229803_co_py
crappy15446803crappy
croupy13458733croupy
cuppy144710383_cuppy
dippy135111543_dippy
dopey116020353_dopey
dopy106224153_do_py
drippy14445653drippy
droopy12458243droopy
dropsy12497473dropsy
elope75219343elo_pe
eloped95914143eloped
eloper85414153eloper
elopes85918163elopes
felonry13294843felonry
felony123710323felo_ny
flabby1634573flabby
flaggy14415923flaggy
flakey164410513flakey
flaky155715583fl_aky
flamy135217473fl_amy
flap96128703fl_ap_
flapped15328253flapped
flapper14359203flapper
flaps105621383fl_aps
flashy15498173flashy
flatly123110213flatly
flawy145913383fl_awy
flaxy189012293fl_axy
flay106332803fl__ay
flecky18387653flecky
fledgy14414913fledgy
fleecy14266483fleecy
fleshy15406283fleshy
fleury12417353fleury
fley106626853fl__ey
flimsy14345563flimsy
flinty126112493flinty
flip96324263fl_ip_
flipped15358513flipped
flipper14389143flipper
flips105117743fl_ips
flirty12499143flirty
float85928573flo_at
floats96816253floats
floc95922123flo__c
flocci1335023flocci
flock144717423flo_ck
flocks154713533flocks
flocs105519233flo_cs
floe76129773flo__e
floes85528143flo_es
flog85523893flo__g
flogs95919963flo_gs
flong95815683flo_ng
flongs105010493flongs
flood95215603flo_od
floods104511653floods
flooie93712153flooie
floor84215233flo_or
floors94112353floors
floppers15337463floppers
floppier1554633floppier
floppies1546823floppies
flopping16388773flopping
flora85317103flo_ra
florae94713883florae
floral94313813floral
floras94715693floras
floret9321123floret
florid10311453florid
florin9312653florin
floss85118263flo_ss
flota85315643flo_ta
flotas94013003flotas
flouncy1543673flouncy
flour84916453flo_ur
flours94414053flours
flout86226203flo_ut
flouts94315273flouts
flow105924923flo__w
flowed133513763flowed
flower124815503flower
flowery16327783flowery
flown116213993flo_wn
flows115822363flo_ws
fluffy14315783fluffy
flukey16459813flukey
fluky154512293fl_uky
flump124614723flump_
flumps135112503flumps
flunky16408093flunky
flurry12397113flurry
flutey125212523flutey
fluty114415643fl_uty
fly97124953fl___y
flyboy17113913flyboy
flyby1676003fl_yby
flyway18134693flyway
foamy135313203f_oamy
fogey125617873f_ogey
foggy136714543f_oggy
fogy115923183f_o_gy
foley115222303f_oley
folksy16484983folksy
folky159214713f_olky
folly115022603f_olly
footsy12587933footsy
footy115820533f_ooty
fop86743703f_o_p_
fopped144012673f_opped
foppery17385623f_oppery
fops96532683f_o_ps
foray115023973f_oray
forby135317673f_orby
forky156119643f_orky
forty114824273f_orty
foxy176517753f_o_xy
foy96044263f_o__y
fozy197017163f_o_zy
frappe13286953frappe
froggy1434493froggy
frosty124710633frosty
frothy15578373frothy
frouzy21395283frouzy
frowsy15498273frowsy
frowzy24485793frowzy
frumpy16466883frumpy
gappy136212033_gappy
globby1434683globby
gloomy12528763gloomy
glop76724633glo_p_
glopped13347613glopped
glops85619553glo_ps
glory96413293glo_ry
glossy10549003glossy
glumpy14527193glumpy
goopy115816623_goopy
grippy14447763grippy
guppy135211273_guppy
happy155813533_happy
hippy155112793_hippy
jalopy18325863jalo_py
koppa13397293_koppa
loamy105913343_loamy
lobby125113923_lobby
lofty115813303_lofty
loggy105714193_loggy
logy87025783_lo_gy
lolly85120663_lolly
looby108115623_looby
looey84822913_looey
loony86918963_loony
loop67835013_loop_
loops75723963_loops
lop58255313_lo_p_
lope65941923_lo_pe
loped85128333_loped
loper75129233_loper
lopes76437343_lopes
lopped114218623_lopped
lopper103717203_lopper
lops66043353_lo_ps
lorry86315673_lorry
lory75931713_lo_ry
lossy85214643_lossy
loup66028433_loup_
loupe75319513_loupe
loups75319623_loups
loury85716753_loury
lousy84617083_lousy
lowly114113333_lowly
lumpy126615913_lumpy
mopey124821823_mopey
mopy115721973_mo_py
myopy15457353myo_py
nappy126312333_nappy
nippy124911113_nippy
ology94113113olo_gy
pappy114713803_pappy
peppy114310363_peppy
ploidy1237483ploidy
plop86625743plo_p_
plopped11288773plopped
plops95920333plo_ps
plotty11208853plotty
ploy96123603plo__y
poppa8409893_poppa
popsy125713403_popsy
preppy1235523preppy
puppy114912413_puppy
quippy22384263quippy
ropey106021873_ropey
ropy96323413_ro_py
roupy106112713_roupy
sappy125413473_sappy
shoppe133110323shoppe
sleepy11479413sleepy
slobby1334803slobby
sloop76118913sloop_
sloops85513623sloops
slop66533873slo_p_
slope75823563slo_pe
sloped94216853sloped
sloper84615913sloper
slopes84820453slopes
slopped123511443slopped
sloppily1544613sloppily
slops75026013slo_ps
sloshy12366623sloshy
slowly1237153slowly
snappy1366103snappy
snippy1374843snippy
snoopy11449473snoopy
soapy106114783_soapy
sophy136611763_sophy
soupy106115403_soupy
stroppy14205093stroppy
swoopy14487283swoopy
tippy125411793_tippy
trippy13457803trippy
trophy1438283trophy
whippy19385843whippy
yuppy15487913_yuppy
zappy21548943_zappy
zippy21518743_zippy
zloty17399793zlo_ty

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.423422437.4
2DLD Change Limit1127162814.87623116.5
3Display Results2812810.0763697.4
 (SQL Overall)1786912815.37533244.8
 
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.