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

478 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
floaty12421094(None) 
float85928571float_
floats96816251floats
afloat9315152afloat_
bloat75229922bloat_
bloats85215762bloats
blotty11178342blotty
clotty11208262clotty
flaky155715582fl_aky
flamy135217472fl_amy
flat77147822fl_at_
flatly123110212fl_atly
flats86429742fl_ats
flawy145913382fl_awy
flaxy189012292fl_axy
flay106332802fl_a_y
flinty126112492flinty
flirty12499142flirty
floated113312702floated
floatel10308012floatel
floater104413352floater
flocky18468422flocky
flokati1443482flokati
flooey123910172flooey
floosy12368152floosy
floozy21356612floozy
floppy1654872floppy
flossy12517702flossy
flota85315642flo_ta
flotas94013002flotas
floury12449572floury
flout86226202flout_
flouts94315272flouts
fluty114415642fl_uty
foamy135313202f_oamy
folate93320392folate
footy115820532f_ooty
forty114824272f_orty
frosty124710632frosty
gloat65427682gloat_
gloats74515422gloats
loamy105913342_loamy
loath84918602_loath
lofty115813302_lofty
platy105021662pl_aty
plotty11208852plotty
slaty86523152sl_aty
zloty17399792zlo_ty
agouty10366913agouty
alary86123443al_ary
alate55340323al_ate
albata839333albata
allay85620393alla_y
aloft8423433aloft_
alway116113923alwa_y
blasty115611053blasty
blat66550953bl_at_
blate75933783bl_ate
blats75132503bl_ats
bleary115112553bleary
bleat75737003bleat_
bleats85518613bleats
bloated104513433bloated
bloater94013423bloater
blocky17388353blocky
bloody124710173bloody
blooey115110793blooey
bloomy134510113bloomy
blot65842323blo_t_
blots75626173blo_ts
blotto8198443blotto
blousy11459123blousy
blowby16467513blowby
blowsy14579453blowsy
blowy134315323blo_wy
blowzy23516673blowzy
boat66360313_boat_
boats75635153_boats
booty106125913_booty
borty105522833_borty
clary105719613cl_ary
clay95927413cl_a_y
cleat76335063cleat_
cleats84919313cleats
cloaca1037263cloaca
cloak115214013cloa_k
cloaks124411263cloaks
cloddy13405233cloddy
cloggy1344873cloggy
cloot76127053cloot_
cloots85113693cloots
clot66542423clo_t_
cloth105817543clo_th
clots75627643clo_ts
cloudy12517803cloudy
clout75330463clout_
clouts87017203clouts
cloy96623833clo__y
coaly105521593_coaly
coat67558343_coat_
coati75624633_coati
coats75634993_coats
croaky15528483croaky
doat56947673_doat_
doats65224883_doats
dorty96220813_dorty
dotty94516103_dotty
doty86128223_do_ty
elate55335883el_ate
eluate62315433eluate
falcate12311613falcate
fallacy1536433fallacy
falsity1335903falsity
fat68178083f__at_
fate75444283f__ate
fatly115716803f__atly
fats76252503f__ats
fatty115117413f_atty
faulty12429363faulty
fay97454863f__a_y
fealty122910223fealty
feat76458223f_eat_
featly123711753f_eatly
feats86432753f_eats
feisty12449293feisty
fellate10313433fellate
felonry13294843felonry
felony123710323felo_ny
feodary1444713feodary
ferity122813343ferity
fiat76646643f_iat_
fiats85324483f_iats
fifty145211423f_ifty
filiate10414233filiate
fixate1638733fixate
fixity19427803fixity
flab96628353fl_a_b
flabby1634573flabby
flabs105818643fl_abs
flack144519413fl_ack
flag87427083fl_a_g
flaggy14415923flaggy
flags95321283fl_ags
flail85316183fl_ail
flair86114123fl_air
flak116026173fl_a_k
flake125119973fl_ake
flakey164410513flakey
flam96333293fl_a_m
flame105124443fl_ame
flams105125013fl_ams
flan76134183fl_a_n
flank124618093fl_ank
flans85327973fl_ans
flap96128703fl_a_p
flappy1654483flappy
flaps105621383fl_aps
flare84823633fl_are
flash115716213fl_ash
flashy15498173flashy
flask125512423fl_ask
flatus94310783fl_atus
flaunty1354413flaunty
flauta937823flauta
flaw106326643fl_a_w
flaws115920343fl_aws
flax147325633fl_a_x
flays116321053fl_ays
flea75628493flea__
fleam106017283flea_m
fleams115011943fleams
fleas86423663flea_s
flecky18387653flecky
fledgy14414913fledgy
fleecy14266483fleecy
fleet85932333fleet_
fleetly1336313fleetly
fleets96915063fleets
fleshy15406283fleshy
fleury12417353fleury
fley106626853fl__ey
flighty17347433flighty
flimsy14345563flimsy
flint87333503flint_
flints95617453flints
flippy1654613flippy
flirt87424753flirt_
flirts95411483flirts
flit76539273fl_it_
flite85424963fl_ite
flits85625223fl_its
floatage1244403floatage
floatels11295663floatels
floaters112711503floaters
floatier1136983floatier
floating123111883floating
floc95922123flo__c
flocci1335023flocci
flock144717423flo_ck
flocks154713533flocks
flocs105519233flo_cs
floe76129773flo__e
floes85528143flo_es
flog85523893flo__g
flogs95919963flo_gs
flokatis1543123flokatis
flong95815683flo_ng
flongs105010493flongs
flood95215603flo_od
floods104511653floods
flooie93712153flooie
floor84215233flo_or
floors94112353floors
flop96925453flo__p
flops105920143flo_ps
flora85317103flo_ra
florae94713883florae
floral94313813floral
florally1447033florally
florals104210063florals
floras94715693floras
floret9321123floret
florets1039853florets
florid10311453florid
florin9312653florin
floss85118263flo_ss
flotage1136673flotage
flouncy1543673flouncy
flour84916453flo_ur
flours94414053flours
flouted113210813flouted
flouter104311343flouter
flow105924923flo__w
flowage1435723flowage
flowed133513763flowed
flower124815503flower
flowery16327783flowery
flown116213993flo_wn
flows115822363flo_ws
fluffy14315783fluffy
flukey16459813flukey
fluky154512293fl_uky
flunky16408093flunky
flurry12397113flurry
flute86823753fl_ute
flutey125212523flutey
fluyt114614203fluyt_
fluyts12367153fluyts
fly97124953fl___y
flyaway1943163flyaway
flyboat1546003flyboat_
flyboats1643863flyboats
flyboy17113913flyboy
flyby1676003fl_yby
flyte115713943fl_yte
flyway18134693flyway
foal76630923f_oa_l
foals85721693f_oals
foam97127173f_oa_m
foams105017953f_oams
fogey125617873f_ogey
foggy136714543f_oggy
fogy115923183f_o_gy
folates103218453folates
foley115222303f_oley
foliate10513533foliate
folksy16484983folksy
folky159214713f_olky
folly115022603f_olly
font77143753f_ont_
fonts86124753f_onts
foot76248013f_oot_
foots85528283f_oots
footsy12587933footsy
foray115023973f_oray
forby135317673f_orby
forky156119643f_orky
fort76456443f_ort_
forte86131463f_orte
forth116222673f_orth
forts86034453f_orts
foxy176517753f_o_xy
foy96044263f_o__y
fozy197017163f_o_zy
frat75648543f_rat_
frats86829673f_rats
fray105428903f_ra_y
freaky16439233freaky
fretty1249223fretty
friary124010093friary
froggy1434493froggy
front85029223front_
fronts94415793fronts
frost84727833frost_
frosts94214623frosts
froth115919283fro_th
frothy15578373frothy
frouzy21395283frouzy
frowsty16464983frowsty
frowsy15498273frowsy
frowzy24485793frowzy
fruity12429693fruity
fugato1036223fugato
fusty115016513f_usty
ghosty13467213ghosty
glady105413943gl_ady
glary96018543gl_ary
glazy187410983gl_azy
gleamy12398113gleamy
gleety10479193gleety
glinty106910693glinty
gloam86015943gloa_m
gloams95210663gloams
gloated93511533gloated
gloater83711013gloater
globate1057823globate
globby1434683globby
gloomy12528763gloomy
gloppy1454723gloppy
glory96413293glo_ry
glossy10549003glossy
glost65422933glost_
glosts74513813glosts
glout65925813glout_
glouts74414713glouts
goat56250833_goat_
goats65527303_goats
gouty95217363_gouty
groat65531973groat_
groats74816653groats
grotty10389833grotty
grouty104710983grouty
hoagy124710473_hoagy
hoary114516763_hoary
hooty115022433_hooty
jolty155713033_jolty
jotty155012603_jotty
knotty13315223knotty
lacy95829633_l_acy
lady86527153_l_ady
laity85318903_laity
laky116725823_l_aky
lat37593403_l_at_
late47560483_l_ate
lath76640383_l_ath
lathy115215063_l_athy
lati46438273_l_ati
lats45962703_l_ats
latu47934183_l_atu
lay68865353_l_a_y
lazy166423073_l_azy
leady95618603_leady
leafy116316213_leafy
leaky125217723_leaky
lealty92910603_lealty
leary85927383_leary
leavy115715773_leavy
lefty115613563_lefty
linty87126563_linty
loach105116363_loach
load56730603_loa_d
loads65323373_loads
loaf76734903_loa_f
loafs85616993_loafs
loam65630483_loa_m
loams75619863_loams
loan47436453_loa_n
loans56026463_loans
loathe94211383_loathe
loathly1334713_loathly
lobate82915243_lobate
lobby125113913_lobby
locate83919843_locate
loft76539143_loft_
lofts85518363_lofts
loggy105714193_loggy
logy87025783_lo_gy
lolly85120663_lolly
looby108115623_looby
looey84822913_looey
loony86918963_loony
loopy105316643_loopy
loot46955823_loot_
loots55431423_loots
loppy125911663_loppy
lorry86315663_lorry
lory75931713_lo_ry
lossy85214643_lossy
lost47951493_lost_
lot38179263_lo_t_
lota47233503_lo_ta
lotah85315853_lotah
lotas55926303_lotas
loth76132133_lo_th
loti46431833_lo_ti
lots47652093_lo_ts
lotte54923853_lotte
lotto55217573_lotto
loury85716753_loury
lousy84617083_lousy
lout45952143_lout_
louts56330273_louts
lovat8321043_lovat_
lovats939073_lovats
lowly114113333_lowly
loyalty13114343_loyalty
lusty85417573_lusty
meaty107021313_meaty
moat66352033_moat_
moats75827643_moats
oaky116419953__oaky
oat39888263__oat_
oath76132153__oath
oats46554213__oats
oleate6318883oleate
ology94113113olo_gy
paty95234563__paty
peaty105725693_peaty
plat66048873pl_at_
plate74635113pl_ate
plats75531373pl_ats
platys11459853pl_atys
play95928983pl_a_y
pleat74734473pleat_
pleats85218593pleats
plenty11311413plenty
ploidy1237483ploidy
plot66141233plo_t_
plots75025673plo_ts
plotz164616993plo_tz
ploy96123603plo__y
polity113015863polity
potty105621003_potty
pouty107018813_pouty
refloat10310833refloat_
refloats1156913refloats
rooty86423023_rooty
shoaly124010763shoaly
shoat85633943shoat_
shoats94117073shoats
shorty124313193shorty
slanty95114843slanty
slat46959023sl_at_
slate55438283sl_ate
slatey95417063sl_atey
slats55436903sl_ats
slay76436383sl_a_y
sleazy18267393sleazy
sleety94112653sleety
slitty9329163slitty
slobby1334803slobby
sloppy1395303sloppy
sloshy12366623sloshy
slot46049823slo_t_
sloth85019443slo_th
slots54830523slo_ts
slowly1237153slowly
slutty9248003slutty
snooty94211503snooty
snotty9489193snotty
snouty9419953snouty
soapy106114783_soapy
softy115414483_softy
solate64526073solate
sooty84924833_sooty
sporty115112493sporty
spotty11448573spotty
stoat57135953stoat_
stoats65117483stoats
sweaty123710053sweaty
throaty13428483throaty
toady96814343_toady
toasty9509563_toasty
treaty94414353treaty
trouty95211793trouty
zlote143912943zlo_te
zlotys18374173zlo_tys
zooty175415353_zooty

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 Filter1786911127160.1731032896.0
2DLD Change Limit1127164785.96618893.1
3Display Results4784780.2961614.9
 (SQL Overall)1786914786.43527768.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.