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

417 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
flooie9371215(None) 
blooie83913191blooie
floosie10378931floosie
floozie19295461floozie
looie55624241_looie
floe76129772fl_o_e
flood95215602floo_d
flooded12307932flooded
flooder11258462flooder
floods104511652floods
flooey123910172flooey
floor84215232floo_r
floored11268682floored
floorer10248072floorer
floors94112352floors
floosies113210232floosies
floosy12368152floosy
floozies20326952floozies
floozy21356612floozy
florae94713882florae
florid10311452florid
florin9312652florin
flossie10337442flossie
fogie96719002f_ogie
folkie13369612folkie
foodie104413842foodie
footie94718142footie
looies65025832_looies
loonie64216452_loonie
loose56627682_loose
louie55023512_louie
alcove1178083alcove
aldose7311093aldose
algoid83011473algoid
alkie95520033al_kie
alodia71112453alodia
aloe45540193al_o_e
aloin55227423al_oin
alone55732963al_one
aloof83521573aloo_f
anomie83215963anomie
bloke114316633bl_oke
blonde94813293blonde
blood85319523bloo_d
blooded11379803blooded
bloodied1245973bloodied
bloodier1136823bloodier
bloodies11310163bloodies
bloods94614843bloods
bloody124710173bloody
blooey115110793blooey
bloom95918973bloo_m
bloomed12439433bloomed
bloomer11419813bloomer
bloomier1275783bloomier
blooms104613173blooms
bloomy134510113bloomy
bloop96116153bloo_p
blooped12398543blooped
blooper11358533blooper
bloops106611343bloops
blouse84714723blouse
blowier1248943blowier
bogie89524103_bogie
boobie104015293boobie
boogie93515993boogie
bookie123516003bookie
bootie85421163bootie
booze164718913_booze
brookie1347373brookie
calorie92716893calorie
choose115116143choose
cleome1039083cleome
cloche134312373cloche
clone75728163cl_one
clonic104914673clonic
cloot76127053cloo_t
cloots85113693cloots
cloque17288743cloque
close76425223cl_ose
clothe114712993clothe
clove105619443cl_ove
cloze165517543cl_oze
collie83621993collie
colone85425003colone
cooee74531023_cooee
cookie123716043cookie
coolie83821603coolie
cootie84223093cootie
cosie74728263_cosie
cozie163519133_cozie
dhootie1136473dhootie
dobie84920333_dobie
dogie75222793_dogie
doobie94712683doobie
doolie73916833doolie
doozie163910653doozie
dowie94721143_dowie
doxie136017153_doxie
eloin55923203el_oin
elope75219343el_ope
faerie93514683faerie
falsie93513853falsie
farcie114816473farcie
feirie939553feirie
felloe93513923fello_e
felonies11310993felonies
ferlie92814053ferlie
fie67152443f___ie
filose96112503filose
flail85316183fl_ail
flair86114123fl_air
flake125119973fl_ake
flakier143910203flakier
flambe13489153flambe
flame105124443fl_ame
flamier123112143flamier
flange103411973flange
flare84823633fl_are
flavin1239303flavin
flavine1338453flavine
flavone1335523flavone
flawier13378733flawier
flaxier17337983flaxier
fleche14299303fleche
fledge11439313fledge
flee76238793fl__ee
fleece11369903fleece
flense938903flense
flexile1735073flexile
flic96223733fl__ic
flied96519433fl__ied
flier86023403fl__ier
flies85630713fl__ies
flip96324263fl__ip
flir76422203fl__ir
flit76539273fl__it
flite85424963fl_ite
float85928573fl_oat
floated113312703floated
floatel10308013floatel
floater104413353floater
floatier1136983floatier
floats96816253floats
floaty124210943floaty
floc95922123fl_o_c
flocced15365483flocced
flocci1335023flocci
floccose1543133floccose
flock144717423fl_ock
flocked174510253flocked
flockier1745343flockier
flocks154713533flocks
flocky18468423flocky
flocs105519233fl_ocs
floes85528143fl_oes
flog85523893fl_o_g
flogged13528803flogged
flogger12449463flogger
flogs95919963fl_ogs
flong95815683fl_ong
flongs105010493flongs
flooders12257833flooders
flooding13238963flooding
floodlit1244073floodlit
floodtide14102483floodtide
floorage1275093floorage
floorers11227573floorers
flooring12259883flooring
flop96925453fl_o_p
flopover1642863flopover
flopped15338763flopped
flopper14328473flopper
floppier1554633floppier
floppies1546813floppies
floppy1654873floppy
flops105920143fl_ops
flora85317103fl_ora
floral94313813floral
floras94715693floras
floret9321123floret
florigen12154633florigen
florins10311643florins
florist10314243florist
floruit1047293floruit
floss85118263fl_oss
flossed11388533flossed
flosser10339693flosser
flosses103411973flosses
flossier11326973flossier
flossies112810123flossies
flossy12517703flossy
flota85315643fl_ota
flotage1136683flotage
flotas94013003flotas
flounce1235413flounce
flour84916453fl_our
floured11289873floured
flours94414053flours
floury12449573floury
flout86226203fl_out
flouted113210813flouted
flouter104311343flouter
flouts94315273flouts
flow105924923fl_o_w
flowage1435723flowage
flowed133513763flowed
flower124815503flower
flowing143411763flowing
flown116213993fl_own
flows115822363fl_ows
flue75329853fl__ue
fluid94013963fl_uid
fluke125016893fl_uke
flukier14397853flukier
flume106021173fl_ume
flunkie1434513flunkie
fluor84512773fluo_r
fluoric1245813fluoric
fluorid1136783fluorid
fluoride1245873fluoride
fluorin1037233fluorin
fluorine1147813fluorine
fluorite1147893fluorite
fluors94311373fluors
flute86823753fl_ute
flutier103011553flutier
flyoff1444023flyoff
flyover1633513flyover
flyte115713943fl_yte
flytier13356503flytier
foci94521013f_oci_
foe66350813f__o_e
fogies104118063f_ogies
foil76433913f__oil
foin77231563f__oin
folate93320393folate
folia83618933f_olia
folic105319323f_olic
folio83820883f_olio
folioed1138033folioed
folios93915463folios
foliose10378013foliose
folkier14359043folkier
folkies143612253folkies
follies103618943follies
follis93113903follis
fomite113314073f_omite
food86830573f_oo_d
foodies113416753foodies
foods95924163f_oods
fool75330593f_oo_l
fooled104317823f_ooled
fools86824203f_ools
foot76248013f_oo_t
footed104418623f_ooted
footer94320773f_ooter
footier104115113footier
footies103721543footies
footle93914383footle
foots85528283f_oots
footsie1047653footsie
footy115820533f_ooty
foozle18369203foozle
force105324273f_orce
fore78351473f__ore
forge95126943f_orge
forme105225993f_orme
forte86131463f_orte
fosse86119463f_osse
foxier163910033f_oxier
fozier183710663f_ozier
froe75329993f_ro_e
frolic1149203frolic
frore86218803f_rore
froze174515653f_roze
fucoid1237893fucoid
fucose11167683fucose
fulsome1245363fulsome
furore9410013furore
globe84917013gl_obe
globin9309723globin
globoid1145973globoid
globose1035543globose
glonoin875673glonoin
gloom87116523gloo_m
gloomed11337413gloomed
gloomier1135093gloomier
glooms96211683glooms
gloomy12528763gloomy
gloria71910543gloria
gloried9169513gloried
glories81915913glories
glove94516293gl_ove
gloze154815983gl_oze
goodie83613993goodie
gooier73516213_gooier
goonie73615563goonie
goose65925903_goose
groove10438873groove
homie104622533_homie
hoodie105116143hoodie
hoolie93217783hoolie
kloof123812133kloo_f
kloofs13386353kloofs
kookie9389843kookie
leone55018823_leone
lie38264523_l__ie
lobe65535363_l_obe
loci66126283_loci_
lode56240113_l_ode
lodge76520093_lodge
loge56837193_l_oge
loggie84011993_loggie
logia68116603_logia
logic88217833_logic
logier75015733_logier
login66025003_login
logoi69715943_logoi_
loid55531493_l_oid
loin46838723_l_oin
lone45849133_l_one
longe66626463_longe
loo38359823_loo__
loobies93814103_loobies
looby108115623_looby
looed64626133_looed
looey84822913_looey
loof78141053_loo_f
loofa85912813_loofa
loofs85623783_loofs
looing73621043_looing
look87333473_loo_k
looked114717073_looked
looker104816953_looker
looks95124863_looks
loom67035053_loo_m
loomed94616763_loomed
looms75124643_looms
loon47344793_loo_n
looney94712413_looney
loonier73312683_loonier
loonies73919543_loonies
loons55731723_loons
loony86918963_loony
loop67835013_loo_p
looped95217173_looped
looper83817113_looper
loopier93711193_loopier
loops75723963_loops
loopy105316643_loopy
loos49051123_loo_s
loosed75520893_loosed
loosen66615963_loosen
looser65219943_looser
looses67328243_looses
loot46955823_loo_t
looted74421113_looted
looter64222323_looter
loots55431423_loots
lope65941923_l_ope
lore45850353_l_ore
lories64933043_lories
loris55329153_loris
lose45144583_l_ose
loti46431843_loti_
lotic76420673_lotic
lotte54923853_lotte
louies64525103_louies
louis57322323_louis
loupe75319513_loupe
louse56131013_louse
love75234763_l_ove
lowe75435313_l_owe
lowse87219903_lowse
mollie83517103mollie
monie75631653_monie
moose76327193_moose
movie105319133_movie
moxie144018123_moxie
noogie73612313noogie
nookie103712433nookie
noose55624063_noose
oldie6415473ol_die
ologies8615023ologies
oorie53026363_oorie
ooze136420603__ooze
plie65127393pl__ie
plosive1236673plosive
poove104514303_poove
roofie93411173roofie
rookie103613263rookie
roomie83013873roomie
roose56127093_roose
sloe45534953sl_o_e
sloid64619713sl_oid
sloop76118913sloo_p
sloops85513623sloops
slope75823563sl_ope
snooze15439993snooze
stogie7311323stogie
stooge73811663stooge
stoolie739723stoolie
toonie63617993toonie
towie85821873_towie
twoonie1034423twoonie
unloose797863unloose
vogie95116663_vogie
whoopie15295933whoopie
woodie103513613woodie
woolie93514483woolie
yowie114616453_yowie
zlote143912943zl_ote
zloties1639913zloties
zooid15312103_zooid
zooier153411233_zooier
zowie174313843_zowie

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.373479064.3
2DLD Change Limit1127164175.54620323.8
3Display Results4174170.1402978.6
 (SQL Overall)1786914176.05929491.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.