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

473 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
crowded1441878(None) 
crowder13389841crowder
crowed124717291crow_ed
crowned133912421crowned
becrowded1842922becrowded
brooded113510932brooded
browed125216392brow_ed
browned134710972browned
browsed134511232browsed
chorded144710552chorded
chowder16387802chowder
chowed154914642chow_ed
chowsed16478602chowsed
clouded11348832clouded
clowder13367932clowder
clowned13447722clowned
codded114515302c_odded
coded95433182c_o_ded
corded105923352c_orded
cowed115637842c_ow_ed
cowled125218382c_owled
crawdad1443112crawdad
crawled133710392crawled
crewed125316552crew_ed
croaked143710532croaked
crocked164014432crocked
crooked143910942crooked
crooned103813342crooned
cropped143812062cropped
crossed105313892crossed
crowd115815622crow__d
crowdedly1942282crowdedly
crowders14398792crowders
crowdie1335902crowdie
crowdies1437542crowdies
crowds124910762crowd_s
crowdy15467172crowd_y
crower114117552crow_er
crowner124012592crowner
crownet123714112crownet
crudded1235732crudded
drownded14334432drownded
drowned12419902drowned
drowsed12448742drowsed
eroded84313582ero_ded
fronded12388862fronded
frowned14348832frowned
growled12278162growled
prodded1257732prodded
prowled13309902prowled
rodded93713702_rodded
rowed94034322_row_ed
trowed104714652trow_ed
uncrowded1654132uncrowded
aboded104912513abo_ded
accorded14155343accorded
arcaded1178973arcaded
aroused84914343aroused
arrowed1148103arrow_ed
avoided1235553avoided
avowed1335953avow_ed
blooded11379803blooded
blowed125016693blow_ed
blowsed13449023blowsed
blowzed22435973blowzed
boded95124963_bo_ded
bonded104719953_bonded
bowed114533423_bow_ed
bowled125018133_bowled
bowsed125715973_bowsed
bradded12388713bradded
braided114013213braided
branded114414103branded
brawled133910123brawled
breaded115014063breaded
brewed125411873brew_ed
brinded115112053brinded
broaden10289143broaden
broader103412603broader
brocaded1436353brocaded
broider103912973broider
broiled103811423broiled
bronzed19308213bronzed
brooder103811623brooder
brooked143610033brooked
broomed124111053broomed
browner124911643browner
browse115713853browse_
browser124911143browser
browses124712693browses
carded105424903c_arded
caroled103717683caro_led
carolled1138823carolled
caromed123713623caro_med
caroused1149253caroused
cawed116627063c_aw_ed
ceded96118553c__eded
chawed155214603chaw_ed
chewed154415013chew_ed
chided135113963c_hided
chocked194411613chocked
choired13349343choired
choked164914793cho_ked
chomped17329773chomped
chopped174511003chopped
chored125321883cho_red
choused135012463choused
chowdered1944003chowdered
chowders17387533chowders
chowse144711753chowse_
chowses155611283chowses
chromed153510923chro_med
cladded12356923cladded
clawed125115073claw_ed
clewed1225113203clew_ed
cloaked14368543cloaked
clocked164112833clocked
clogged12528653clogged
clomped14398973clomped
cloned94518803clo_ned
clonked14429563clonked
clopped143611523clopped
closed95317963clo_sed
clothed134010283clothed
clotted104011823clotted
cloured103111543cloured
clouted104212163clouted
clowders14357473clowders
cloyed125111563clo_yed
coaled95022703c_oaled
coated94927033c_oated
coaxed165612513c_oaxed
cocked155022563c_ocked
codder104416333c_odder
coddled123410573c_oddled
code77347733c_o_de_
codec107120343c_o_dec
coden86128543c_o_den
coder86134213c_o_der
codes86247293c_o_des
codex155817573c_o_dex
coed77140543c_o__ed
cogged116416613c_ogged
coifed124113063c_oifed
coiled95123933c_oiled
coined94523603c_oined
coked124730693c_o_ked
colder95121833c_older
coled85540753c_o_led
combed135516543c_ombed
comped135919873c_omped
coned86040053c_o_ned
conked135019113c_onked
conned95119703c_onned
cooed84534343c_o_oed
cooeed95917863c_ooeed
cooeyed1346893cooeyed
cooked135921363c_ooked
cooled95224583c_ooled
cooped114821603c_ooped
coopted123710763coopted
coped105036843c_o_ped
copied114618563c_opied
copped135221253c_opped
corder94322873c_order
cored85044223c_o_red
corked135020783c_orked
corned95224523c_orned
cornfed1337383cornfed
corraded12128293corraded
corroded12147513corroded
coshed124217543c_oshed
cosied94819883c_osied
costed95623113c_osted
coted85033853c_o_ted
coude85022633c_oude_
couped115019313c_ouped
coved115027373c_o_ved
coward12411673c_oward
cower104531773c_ow_er
cowered133214643c_owered
cowherd1636953c_owherd
cowhided1843743c_owhided
cowier113616163c_owier
cowmen13810923c_owmen
cowpea1337643c_owpea
cowshed1637773c_owshed
coxed154322813c_o_xed
coyed114623803c_o_yed
cozied184112153c_ozied
craaled10339423craaled
crabbed14388873crabbed
cracked163514743cracked
cradled113410813cradled
crafted13419773crafted
cragged12479883cragged
crammed143710123crammed
cramped144712183cramped
craned96121653cr_aned
cranked143812843cranked
craped116120523cr_aped
crapped143912623crapped
crashed134214203crashed
crated94827773cr_ated
craved125417773cr_aved
crawdads1542653crawdads
crawler123510453crawler
crazed184714453cr_azed
creaked143413233creaked
creamed123913713creamed
creased104315583creased
created104323443created
cred76530883cr___ed
creed85727393cr__eed
creeled104012013creeled
creeped12329713creeped
creped114115703cr_eped
crested103416533crested
crewel114310473crew_el
crewmen1436373crewmen
cribbed14407663cribbed
cricked164814283cricked
cried84624283cr__ied
crimped143910763crimped
cringed113312403cringed
crisped124010103crisped
croaker133010683croaker
crochet143616663crochet
crocket154615673crocket
crofter12299573crofter
crone75231333cro_ne_
crones84729243cro_nes
cronies9622503cronies
crooker134111093crooker
crooner93714043crooner
cropper133312963cropper
croquet1859683croquet
crore74922863cro_re_
crores86121163cro_res
crosier94116573crosier
crosse85216303crosse_
crosser95015463crosser
crosses94220793crosses
crotched16428593crotched
crouched16359143crouched
croupe105114433croupe_
croupes114613103croupes
crouse84619363crouse_
croute84617273croute_
croutes94815643croutes
crow96428133crow___
crowbar1444253crowbar
crowding15247933crowding
crowers124614893crowers
crowfeet1645553crowfeet
crowing133814763crowing
crown105620083crow__n
crowners133710743crowners
crownets13407673crownets
crowns115615113crow_ns
crows105727313crow__s
crowstep1543333crowstep
croze164719453cro_ze_
crozer175112843cro_zer
crozes174417663cro_zes
crozier18369933crozier
crude86018573cr_ude_
cruder95612383cr_uder
crudes96218623cr_udes
cruised103710213cruised
crumbed14378473crumbed
crumped144311223crumped
crusaded1244233crusaded
crushed134111963crushed
crusted103712753crusted
cudweed1444213cudweed
curded104217163c_urded
decrowned1663653decrowned
dowed104632613_dow_ed
downed115314783_downed
dowsed115015013_dowsed
drawled12368343drawled
dreaded103612023dreaded
drolled93810223drolled
droned84616863dro_ned
drooled9369203drooled
drooped11368433drooped
dropped13329283dropped
drouked1335543drouked
droved114611643dro_ved
drownd11478313drow_nd
drowner11369803drowner
drowse105010553drowse_
drowses114610233drowses
erode64520993ero_de_
erodes74819883ero_des
escrowed1434653escrow_ed
flooded12307933flooded
flowed133513763flow_ed
folded114212793_folded
fonded115717043_fonded
forded115020393_forded
fowled133914093_fowled
frocked17439333frocked
frogged13408493frogged
fronted114011273fronted
frosted113211873frosted
frothed14288783frothed
froward1436673froward
frowner13429683frowner
frowsted1534313frowsted
glowed114913833glow_ed
goaded94913713_goaded
godded104811803_godded
gowned114410133_gowned
graded94919553gr_aded
gridded11387583gridded
grided95117043gr_ided
grinded104210633grinded
groaned9259973groaned
groined92710813groined
grokked1233673grokked
groomed11379503groomed
grooved12347253grooved
groped107515053gro_ped
grossed93812253grossed
grounded1136573grounded
grouped11419193grouped
groused94712833groused
grouted94111503grouted
groved114413703gro_ved
grower104614933grow_er
growler11318973growler
hooded114616743_hooded
horded115420483_horded
howdied15296843_howdied
howked177312343_howked
howled134014963_howled
ironed74916013iro_ned
ironweed1244043ironweed
jowed164724423_jow_ed
jowled174210793_jowled
loaded84616873_loaded
loided83414023_loided
lorded84916733_lorded
lowed95233903_low_ed
meowed12148003meow_ed
molded104414083_molded
mowed113629013_mow_ed
nodded94012123_nodded
oroide7311703oroide_
oroides8311973oroides
outcrowded1743153outcrowded
owed86833873__ow_ed
owned95113233__owned
plodded1265563plodded
plowed124213203plow_ed
podded115012713_podded
ponded105218773_ponded
powder123611903_powder
prawned1346743prawned
preowned1435213preowned
prided103618033pr_ided
probed114114823pro_bed
proceed12310543proceed
prodder1147953prodder
progged12409793progged
promoed12310083promoed
pronged113912393pronged
proofed13138723proofed
propped113311953propped
prosed94921093pro_sed
prouder10310373prouder
proved125016033pro_ved
provided1536843provided
prower114218123prow_er
prowler123310013prowler
radded94716493_radded
raided85017703_raided
recrowned1564853recrowned
redded94019543_redded
reded74829113_r_eded
reeded84022563_reeded
rended84524103_rended
rewed95425453_rew_ed
ridded93615123_ridded
rinded84418983_rinded
roadbed1134793_roadbed
roadeo7510323_roadeo
roamed95215093_roamed
roared75015393_roared
robbed113415193_robbed
robed85323733_ro_bed
rocked135022323_rocked
rode55844303_ro_de_
rodeo65921093_ro_deo
rodes614039083_ro_des
rogued84711473_rogued
roiled74320053_roiled
rolfed104510523_rolfed
rolled74220243_rolled
romped114513653_romped
rondel73212643_rondel
roofed105214743_roofed
rooked114918143_rooked
roomed95218543_roomed
roosed75621593_roosed
rooted75424003_rooted
roped84630803_ro_ped
rosed65930343_ro_sed
rotted74524433_rotted
rouged86717323_rouged
rounded93013503_rounded
rouped95717353_rouped
roused75426443_roused
routed75624333_routed
roved95323553_ro_ved
rowdier11348593_rowdier
rowdies113112693_rowdies
rowdy125711533_rowd_y
rowel84721413_row_el
roweled11269863_roweled
rowen84921153_row_en
rower85430493_row_er
scolded11358853scolded
scowder13286853scowder
scowed124413823scow_ed
scowled13398183scowled
scrawled1445903scrawled
screeded1235633screeded
screwed135710653screw_ed
scrolled1137043scrolled
scrooped1356403scrooped
scrouged1235373scrouged
showed135016963show_ed
shrouded1333593shrouded
slowed104617073slow_ed
snooded94110363snooded
snowed104613613snow_ed
sodded94113303_sodded
sowed94933863_sow_ed
stowed105817203stow_ed
strowed115312143strow_ed
towed95134583_tow_ed
traded85717683tr_aded
trawled113411523trawled
treaded95014283treaded
trended94011763trended
troaked12438253troaked
trocked144312243trocked
trodden934883trodden
trode65322853tro_de_
troked114114583tro_ked
trolled84312263trolled
tromped124210293tromped
trooped104010723trooped
trothed114010973trothed
trotted83711283trotted
trouped103910973trouped
trowel94211463trow_el
troweled12106113troweled
uncrowned1564743uncrowned
unowned1148803unowned
voided114011133_voided
vowed124424573_vow_ed
vroomed13366433vroomed
woaded115211603_woaded
wooded114213683_wooded
worded114316623_worded
wowed124023773_wow_ed
wronged12397673wronged
yowed1253025183_yow_ed
yowled133811083_yowled

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.1731032896.0
2DLD Change Limit1340274736.54620474.6
3Display Results4734730.1732734.1
 (SQL Overall)1786914736.89225927.3
 
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.