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

419 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
florets103985(None) 
floret9321121floret_
clarets94111102clarets
closets94611602closets
ferrets103111392ferrets
flares94521702flare_s
fleets96915062fl_eets
flirts95411482flir_ts
floats96816252flo_ats
floes85528142flo_e_s
floorers11227572floorers
florals104210062florals
floras94715692flor_as
florins10311642florins
florist10314242florist
florists1138812florists
floruits1145152floruits
flouts94315272flo_uts
flowerets1544042flowerets
flowers133413172flowers
fores85847102f_ore_s
forest94926742f_orest
forests104114952f_orests
forgets113813792f_orgets
fortes95327182f_ortes
forts86034452f_or_ts
frets85523402f__rets
lores55045402_lore_s
aborts84916183abor_ts
adorers84411733adorers
adores74420723adore_s
afforest1446343afforest
afforests1543733afforests
aigrets82810533aigrets
alerts64418223aler_ts
aloes54933673alo_e_s
avocets1235453avocets
avosets1036663avosets
barrets94917103barrets
befrets1237613befrets
berets85822523_berets
blares85021633blare_s
blets75324943bl__ets
bloats85215763blo_ats
blokes123813883bloke_s
blots75626173blo__ts
blowers124313593blowers
bluets87215493bl_uets
blurts84412643blur_ts
boreas85421733_boreas
borers85122683_borers
bores76448253_bore_s
borts76735453_bor_ts
burets84321263_burets
carets85330773_carets
choreas124414203choreas
chores114828023chore_s
claret84026573claret_
cloners94514823cloners
clones84526563clone_s
cloots85113693clo_ots
closers94415323closers
closes85425593close_s
closest94312533closest
closet85226603closet_
clots75627643clo__ts
clouts87017203clo_uts
clovers125114663clovers
cloves114918823clove_s
clozes174915563cloze_s
collets93517903collets
coloreds1138093coloreds
colorers10312183colorers
comets105823583_comets
corers85231073_corers
cores76361853_core_s
cornets94820573_cornets
corsets94819803_corsets
corvets124715023_corvets
cosets85824403_cosets
covets114819643_covets
crores86121163crore_s
curets84922343_curets
efforts1334703effor_ts
egrets72712243_egrets
eldress835003eldress
elodeas836963elodeas
elopers95112943elopers
elopes85918163elope_s
facets116316653f_acets
fairest10412293fairest
falconets1444813falconets
fanjets1734803fanjets
farers95924053f_arers
fares85852873f_are_s
farts88336843f_ar_ts
faucets12578443faucets
favorers1465493favorers
fearers104815273fearers
felworts1445953felwor_ts
feres86038183f_ere_s
ferrels10248623ferrels
ferret93021173ferret_
ferrety13287013ferrety
fets75345943f___ets
fibres114312123fibre_s
fidgets12388763fidgets
filarees1187643filarees
filberts1334993filberts
filets94718953f_ilets
fillets103414753fillets
filmsets1353413filmsets
fiords10498623fior_ds
firers94922683f_irers
fires85740753f_ire_s
firsts95110923f_irsts
fjords17405353fjor_ds
flakers143613273flakers
flakes134118873flake_s
flamens124611063flamens
flamers124616363flamers
flames114723693flame_s
flanes94522423flane_s
flare84823633flare__
flared105317603flare_d
flareup1243173flareup
flareups1342473flareups
flaskets1534603flaskets
flatlets1147373flatlets
flats86429743fl__ats
flaunts1056133flaunts
flavorers1563983flavorers
flaxes165015353flaxe_s
flayers133912033flayers
fleas86423663fl__eas
fleers96015793fl_eers
flees85828753fl__ees
fleet85932333fl_eet_
flews115316443fl__ews
flexes164512953flexe_s
fleys117015603fl__eys
fliers94417193fl_iers
flies85630713fl_ie_s
fliest94718433fl_iest
flights143310983flights
flints95617453fl_ints
flirs85518933flir__s
flirt87424753flir_t_
flirted11428673flirted
flirter10318673flirter
flirters11337933flirters
flirty12499143flir_ty
flites95122443flite_s
flits85625223fl__its
float85928573flo_at_
floated113312703floated
floatel10308013floatel
floatels11295663floatels
floater104413353floater
floaters112711513floaters
floaty124210943flo_aty
floccus1443653floccus
flocks154713533flo_cks
flocs105519233flo__cs
floe76129773flo_e__
floggers13387863floggers
flogs95919963flo__gs
flokati1443483flokati
flokatis1543123flokatis
flongs105010493flo_ngs
flooders12257833flooders
floods104511653flo_ods
flooey123910173flooe_y
floored11268683floore_d
floorer10248073floore_r
floorless1243793floorless
floors94112353flo_ors
floppers15337463floppers
flops105920143flo__ps
flora85317103flor__a
florae94713883flor_ae
floral94313813flor_al
floreated1346573floreated
florence1347063florence
florences1446893florences
florid10311453flor_id
florigens13133863florigens
florin9312653flor_in
floruit1047293floruit
floss85118263flo__ss
flossers11307863flossers
flosses103411973flosses
flota85315643flo__ta
flotas94013003flo_tas
floured11289873floure_d
flourless1243533flourless
flours94414053flo_urs
flout86226203flo_ut_
flouted113210813flouted
flouter104311343flouter
flouters11419273flouters
flowed133513763flowe_d
flower124815503flowe_r
flowerers1544503flowerers
floweret1448083floweret_
flowery16327783flowery
flows115822363flo__ws
flues84626923fl_ue_s
flukes135114193fluke_s
flumes115119733flume_s
fluorene1145243fluorene
fluorenes1245173fluorenes
fluorids1245493fluorids
fluorins1137343fluorins
fluorite1147893fluorite
fluorites1257163fluorites
fluors94311373fluor__s
fluters103713683fluters
flutes95421783flute_s
fluxes165212933fluxe_s
fluyts12367153fl_uyts
flybelts1682753flybelts
flyers125712803fl_yers
flyless1335003flyless
flyovers1733673flyovers
flytes123911563flyte_s
foes76543443f_o_e_s
foetus958523f_o_etus
fogeys13509263f_ogeys
foists95413983f_oists
folates103218453folates
folders113514393folders
foleys123810463f_oleys
folles93820473folle_s
foments122912053f_oments
fonts86124753f_o_nts
footers104618333footers
footrest11308853footrest
footrests12244503footrests
foots85528283f_o_ots
forams115115913f_orams
forays124813003f_orays
forbs105720803f_or_bs
forceps14466983f_orceps
forcers124215713f_orcers
forces114422133f_orces
fords95328183f_or_ds
fore78351473f_ore__
foreby1438633f_oreby
foredo10510823f_oredo
forego1038903f_orego
foreguts1245563f_oreguts
foretop12117893f_oretop
foretops13137483f_oretops
forfeits1445803f_orfeits
forgers115218183f_orgers
forges105024263f_orges
forget106326393f_orget_
forints10411833f_orints
forkers144615783f_orkers
forks125324683f_or_ks
formats123113573f_ormats
formers128217953f_ormers
formes114623713f_ormes
forms105327053f_or_ms
fort76456443f_or_t_
forte86131463f_or_te
forth116222673f_or_th
fortis95418613f_ortis
forty114824273f_or_ty
forums114611843f_orums
founts94313383f_ounts
foveas1238623f_oveas
foxes156321093f_oxe_s
foyers125413133f_oyers
frats86829673f__rats
frees86131393f__rees
freres94716173frere_s
fret75845043f__ret_
frits86129103f__rits
froes86126693fro_e_s
froglets1235263froglets
frontes104214163frontes
fronts94415793fro_nts
frore86218803frore__
frosts94214623fro_sts
frowsts13426103frowsts
fuhrers1334813fuhrers
fumets114311813f_umets
furores10310033furore_s
galores82614323galore_s
garrets84413623garrets
glares75518863glare_s
gleets75315053gl_eets
gloats74515423glo_ats
globes94314543globe_s
glorias81610323glorias
glories81915913glories
glosts74513813glo_sts
glouts74414713glo_uts
glovers114310883glovers
gloves104115183glove_s
glowers113412093glowers
glozes164313353gloze_s
godets8410933_godets
gores65740373_gore_s
gorgets94711783_gorgets
hornets104113553_hornets
horsts95817513_horsts
imarets9138643imarets
korats105416063_korats
labrets939363labrets
larees65323113_larees
lares54852633_lare_s
leets54927123_l_eets
lets47147943_l__ets
lobes75331003_lobe_s
lockets134612203_lockets
lodens74315063_lodens
lodes66436913_lode_s
loess55714703_lo_ess
lofts85518363_lo_fts
loges66534203_loge_s
loggets9378913_loggets
loments93413473_loments
loners64225813_loners
looeys95110123_looeys
loots55431423_lo_ots
lopers84424143_lopers
lopes76437343_lope_s
lorans65117603_lorans
lords64923503_lor_ds
lore45850353_lore__
loreal63814313_loreal
lories64933043_lories
loris55329153_lor_is
losels64714583_losels
losers65123583_losers
loses56742013_lose_s
lots47652093_lo__ts
lottes65322753_lottes
louts56330273_lo_uts
lovats939073_lovats
lovers94223433_lovers
loves85332013_love_s
lowers94624923_lowers
lowes85732463_lowe_s
lowest93915593_lowest
loxes125227473_loxe_s
lunets66914763_lunets
lurers64217493_lurers
lures56138533_lure_s
lyres85019963_lyre_s
morels84820013_morels
mores76249643_more_s
morts75533563_mor_ts
motets84216193_motets
nonets64118703_nonets
ores46056683__ore_s
orts46538333__or_ts
piolets93513193piolets
placets113911223placets
planets93914083planets
plots75025673plo__ts
plovers123611833plovers
plowers123812243plowers
poets76024443_po_ets
poorest9312773poorest
pores75849033_pore_s
ports75934593_por_ts
projets1639163projets
regrets83212923regrets
rets45352563___rets
rosets65819953_rosets
scorers94115323scorers
scores84725923score_s
secrets9311773secrets
shores94830413shore_s
shorts95321743shor_ts
skorts104211303skor_ts
sleets64318873sl_eets
sloes54728873slo_e_s
slopers94213093slopers
slopes84820453slope_s
slots54830533slo__ts
slovens10316573slovens
slowest10168713slowest
snorers74313803snorers
snores64324323snore_s
snorts64116503snor_ts
solerets839693solerets
solonets838233solonets
sorbets93012513_sorbets
sorels63921163_sorels
sores55454283_sore_s
sorest65028003_sorest
sorts54536663_sor_ts
splores91910953splore_s
spores84726613spore_s
sports84619183spor_ts
starets73515923starets
storers75018683storers
stores65533663store_s
storeys10559653storeys
taborets10278063taborets
terrets72913583terrets
tores55352673_tore_s
tortes64826053_tortes
torts56138123_tor_ts
trets55928023__trets
tsores65113663tsore_s
turrets73010673turrets
violets102210003violets
whores125617103whore_s
whorts125111433whor_ts
worsets105512843_worsets
worsts96014333_worsts
worts88631183_wor_ts
yores85031323_yore_s

Search took 8 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.843211970.3
2DLD Change Limit1340274196.45320769.7
3Display Results4194190.1402992.9
 (SQL Overall)1786914197.43624030.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.