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

250 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
flowery1632778(None) 
flower124815501flower_
flowers133413171flowers
lowery124112711_lowery
blower115316572blower_
blowers124313592blowers
bowery146012112_bowery
clovery15407402clovery
clownery1633312clownery
dowery134311662_dowery
flooey123910172flooe_y
floury12449572flo_ury
flowed133513762flowe_d
flowered1546012flowered
flowerer1435452flowerer
floweret1448082floweret
flowerily1842992flowerily
foolery1336692foolery
glower105114932glower_
glowers113412092glowers
lower85830412_lower_
lowers94624922_lowers
plower114315062plower_
plowers123812242plowers
showery16437242showery
slower94016152slower_
towery124012092_towery
avower1236823avower_
avowers1336333avowers
beflower16166273beflower_
beflowers17165823beflowers
blooey115110793blooe_y
bloomery15335693bloomery
blowby16467513blow_by
blowed125016693blowe_d
blowfly1843243blowfly
blowier1248943blowier_
blowsy14579453blow_sy
blowy134315323blow__y
blowzy23516673blow_zy
bootery1238983bootery
bower107328183_bower_
bowers115523703_bowers
brewery15376953brewery
clawer114512783clawer_
clawers123910973clawers
cloner84418093cloner_
cloners94514823cloners
closely1237053closely
closer84918203closer_
closers94415323closers
clover114617123clover_
clovers125114663clovers
clowder13367943clowder_
clowders14357473clowders
cookery164210393cookery
coopery143910273coopery
cower104531773_cower_
cowers114625533_cowers
cowry135512483_cow_ry
crower114117553crower_
crowers124614893crowers
deflower15126073deflower_
deflowers16145643deflowers
dower95027703_dower_
dowers104523293_dowers
dowry126312483_dow_ry
eloper85414153eloper_
elopers95112943elopers
faery116015483f__aery
fakery16509263f_akery
felonry13294843felo_nry
feodary1444713feodary
fernery1335813fernery
fewer115216123f_ewer_
fiery114714793f__iery
finery124512893f_inery
fishery16397733fishery
flackery20295243flackery
flaker134916173flaker_
flakers143613273flakers
flakey164410513flake_y
flamer114919123flamer_
flamers124616363flamers
flattery14338293flattery
flavory1644743flavory
flawed134712723flawe_d
flawier13378733flawier_
flawy145913383flaw__y
flayer124713563flayer_
flayers133912033flayers
fleecy14266483fl_eecy
fleer86020773fl_eer_
fleers96015793fl_eers
fleury12417353fl_eury
fley106626853fl__e_y
flickery20365103flickery
flier86023403fl_ier_
fliers94417193fl_iers
floater104413353floater_
floaters112711513floaters
floaty124210943flo_aty
flocky18468423flo_cky
floe76129773flo_e__
floes85528143flo_e_s
flogger12449463flogger_
floggers13387863floggers
flooder11258463flooder_
flooders12257833flooders
floor84215233flo_or_
floored11268683floored
floorer10248073floorer
floorers11227573floorers
floors94112353flo_ors
floosy12368153flo_osy
floozy21356613flo_ozy
flopper14328473flopper_
floppers15337463floppers
floppy1654873flo_ppy
flora85317103flo__ra
floret9321123flore_t
florets1039853florets
flosser10339693flosser_
flossers11307863flossers
flossy12517703flo_ssy
flouncy1543673flouncy
flour84916453flo_ur_
floured11289873floured
flours94414053flo_urs
flouter104311343flouter_
flouters11419273flouters
flow105924923flow___
flowage1435723flowage
flowerage1643103flowerage
flowerers1544503flowerers
flowerets1544043flowerets
flowerful1852283flowerful
flowerier1544273flowerier
flowering1636053flowering
flowerpot1752863flowerpot
flowing143411763flowing
flown116213993flow__n
flows115822363flow__s
flukey16459813fluke_y
flummery1833053flummery
flurry12397113fl_urry
fluter95316863fluter_
fluters103713683fluters
flutey125212523flute_y
fluttery14376143fluttery
flyer114916253fl_yer_
flyers125712803fl_yers
flyover1633513flyover_
flyovers1733673flyovers
flyway18134693flyw_ay
fogey125617873f_oge_y
folder104317543folder_
folders113514393folders
foley115222303f_ole_y
follower14137073follower_
followers15146183followers
footer94320773footer_
footers104618333footers
foppery17385623foppery
foreby1438633f_oreby
forgery14419303forgery
fowler123712583f_owler_
fowlers133411203f_owlers
foyer116416553f_oyer_
foyers125413133f_oyers
froward1436673froward
frowner13429683frowner_
frowners14377933frowners
frowsty16464983frowsty
frowsy15498273frow_sy
frowzy24485793frow_zy
fullery13337973fullery
glomera1035943glomera
glory96413293glo__ry
glover104513533glover_
glovers114310883glovers
glowed114913833glowe_d
glowered1345753glowered
glowfly1742673glowfly
grocery13336763grocery
grower104614933grower_
growers113612723growers
knower1337083knower_
knowers1436353knowers
leery85919133_l_eery
livery124910903_livery
lonely92912473_lonely
loner55431043_loner_
loners64225813_loners
looey84822913_looe_y
loper75129233_loper_
lopers84424143_lopers
lorry86315673_lo_rry
lory75931713_lo__ry
loser54728673_loser_
losers65123583_losers
lottery10389833_lottery
loury85716753_lo_ury
lovely12339713_lovely
lover85526453_lover_
loverly1346973_loverly
lovers94223433_lovers
lowboy1435903_lowboy
lowe75435313_lowe__
lowed95233903_lowe_d
lowered112711913_lowered
lowes85732463_lowe_s
lowest93915593_lowest
lowly114113333_low_ly
mopery135210973_mopery
mower104523453_mower_
mowers113219403_mowers
onery8414123__onery
plover115312613plover_
plovers123611833plovers
plowboy1743183plowboy
plowed124213203plowe_d
popery134511703_popery
powdery16396123_powdery
power105325953_power_
powers113822323_powers
prower114218123prower_
reflower14126843reflower_
reflowers15125983reflowers
rookery14398313rookery
ropery114313873_ropery
rosery93813283_rosery
rower85430493_rower_
rowers94924573_rowers
shower124315113shower_
showers134612683showers
slavery13407893slavery
slobbery15375663slobbery
sloper84615913sloper_
slopers94213093slopers
slowed104617073slowe_d
slowest10168713slowest
slowly1237153slow_ly
sower85229313_sower_
sowers94923443_sowers
tower85729203_tower_
towers94423673_towers
volery1237873_volery
vower115220793_vower_
vowers124317183_vowers

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 Filter1786911340270.1401276364.3
2DLD Change Limit1340272506.44020811.6
3Display Results2502500.0932688.2
 (SQL Overall)1786912506.67326778.2
 
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.