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

440 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
dreamy1250999(None) 
creamy134811361creamy
dream85120391dream_
dreams94513981dreams
dreamt94615711dreamt
dreary104611671dreary
beamy126218572_beamy
bready124511182bready
bream95121812bream_
breams104815042breams
creaky154911552creaky
cream95721352cream_
creams104715252creams
creasy114612302creasy
deary95826842d_eary
demy105422852d_e_my
deray95024182dera_y
digamy1335892digamy
dram75832002dr_am_
drama85117412dr_ama
drams86025832dr_ams
dray85428092dr_a_y
dread74419022drea_d
dreads84115022dreads
dreamed114310632dreamed
dreamer104110842dreamer
dreamily1435142dreamily
drear65016902drea_r
drears74614252drears
drecky16486332drecky
dreggy12364632dreggy
dressy10518142dressy
freaky16439232freaky
gleamy12398112gleamy
greasy10419462greasy
gremmy1454472gremmy
preamp1238992preamp
ready94821502_ready
ream65841612_ream_
reams75729622_reams
seamy105921272_seamy
steamy115112372steamy
streamy12509482streamy
treaty94414352treaty
abeam9316533abeam_
already1144263already
arame75026623ar_ame
area45843393area__
areae55229743area_e
areal55928733area_l
areally10411243areally
areas55935773area_s
areaway1335913areaway
ariary94114203ariary
army96624183ar__my
array86317143arra_y
aweary1237303aweary
beady114719923_beady
beaky146118023_beaky
beam86939233_beam_
beams95328173_beams
bigamy1436343bigamy
bleary115112553bleary
braky145015813br_aky
braxy175410893br_axy
bray95232903br_a_y
breach134213723breach
bread85523113brea_d
breads95419203breads
break115319403brea_k
breaks124816423breaks
breamed124011593breamed
breast8319633breast
breath113916263breath
breathy15328033breathy
breezy20295853breezy
bregma1134963bregma
briary114912003briary
broomy13449953broomy
cram85635493cr_am_
cramp115120693cr_amp
crampy154710993cr_ampy
crams96229153cr_ams
crazy195511223cr_azy
creak115418433crea_k
creaks124315963creaks
creamed123913713creamed
creamer113714093creamer
creamery15385983creamery
creamily1536363creamily
crease85519573crease
create85126383create
creepy13418803creepy
creme94319323cre_me
crepey135110933crepey
crepy124812703cre_py
cressy11439113cressy
croaky15528483croaky
crummy15365893crummy
dam67457043d__am_
dame77140313d__ame
damn75724323d__amn
damp96228843d__amp
dams77444373d__ams
daresay1135433daresay
datary10310243datary
davy116015523d__avy
day76254113d__a_y
daydreamy1951293daydreamy
dead65434243d_ea_d
deadly113811473d_eadly
deads75726913d_eads
deaf85838403d_ea_f
deafly13389123d_eafly
deair65817193d_eair
deal56347413d_ea_l
deals65435343d_eals
dealt65234283d_ealt
dean56039483d_ea_n
deans66131393d_eans
dear55343603d_ea_r
dearly104615323d_early
dears65736883d_ears
deash95617243d_eash
death94822523d_eath
deathy134210233d_eathy
deave95022333d_eave
decamp1338453decamp
decay114718483d_ecay
decoy115716313d_ecoy
decry115514353d_ecry
deedy104315893d_eedy
deejay1734523deejay
deem75432893d_eem_
deems85421773d_eems
deeply1257013deeply
defame123212433defame
defy114921263d_e_fy
degame102713183degame
degami10279013degami
deify124112763d_eify
deity94316773d_eity
delay94820633d_elay
delly96023873d_elly
deme76536283d_e_me
demo77427553d_e_mo
denary105316863denary
deny86027123d_e_ny
deoxy1648883d_eoxy
derail74218813derail
derat65044083dera_t
derate74531233derate
derats74625063derats
derays105514253derays
derby114715343d_erby
derm76031893d_erm_
derma84918513d_erma
dermal93614343dermal
dermas94116813dermas
derms85022893d_erms
derry94721373d_erry
dewy115419023d_e_wy
dexy156118553d_e_xy
dey77243373d_e__y
diary95016973d_iary
dietary1158663dietary
diram84419473diram_
dirams94413703dirams
direly10311563dire_ly
dirham12378273dirham_
dirhams13376313dirhams
dismay12229473dismay
doomy116018263d_oomy
dormy115817473d_ormy
drab76226453dr_a_b
drably123511613drably
drabs85119673dr_abs
draff125615663dr_aff
draffy16486633draffy
draft95526683dr_aft
drafty13638933drafty
drag64825053dr_a_g
draggy12346823draggy
drags75521113dr_ags
drail65020973dr_ail
drain65222893dr_ain
drake104918303dr_ake
dramady1443553dramady
dramas95814653dr_amas
dramedy1433243dr_amedy
drank104816203dr_ank
drape85319633dr_ape
drapey125010583drapey
drat56247833dr_a_t
drats66628373dr_ats
drave95219273dr_ave
draw85623013dr_a_w
drawl95516013dr_awl
drawly134910723drawly
drawn95614243dr_awn
draws95119373dr_aws
drays95819773dr_ays
dreaded103612023dreaded
dreamers11369003dreamers
dreamful1452963dreamful
dreamier11287293dreamier
dreaming124011063dreaming
drearily1236083drearily
dreck124812803dre_ck
drecks13459203drecks
dredge9308563dredge
dree56638323dre__e
dreed75222843dre_ed
drees65628523dre_es
dreg66821653dre__g
dregs76114863dre_gs
dreich12377723dreich
dreidl835233dreidl
dreigh11246443dreigh
drek96321093dre__k
dreks105714753dre_ks
drench12369593drench
dress65319833dre_ss
drest65530343dre_st
drew86221673dre__w
drifty13418223drifty
drily95816523dr_ily
drippy14445653drippy
drolly105411673drolly
drooly104911073drooly
droopy12458243droopy
dropsy12497473dropsy
drosky14486163drosky
drossy10528473drossy
drowsy13487903drowsy
druggy12344743druggy
drum76521593dr_um_
drumly1235703drumly
drums85415873dr_ums
dry76526033dr___y
dryad10477583drya_d
dryads11436623dryads
dryly12538453dr_yly
dummy134712783d_ummy
dunam8313733dunam_
dunams937833dunams
dweeby1542993dweeby
dynamo1274163dynamo
easy76224493__easy
elmy95616793__elmy
emmy116013243__emmy
enemy1059993ene_my
flamy135217473_flamy
fleam106017283fleam_
fleams115011943fleams
foamy135313203_foamy
frame105821803fr_ame
fray105428903fr_a_y
freak125115243frea_k
freaks134713063freaks
freely12310963freely
fremd115010323fre_md
frenzy2135883frenzy
fretty1249223fretty
friary124010093friary
gamy105427533__gamy
gemmy135211053_gemmy
germy115113663_germy
gleam86916733gleam_
gleams94812253gleams
gram77034583gr_am_
grama85620283gr_ama
gramp106218323gr_amp
grams85327313gr_ams
grapy115416433gr_apy
gravy125512113gr_avy
gray85329893gr_a_y
grease75416233grease
great66034243grea_t
greatly1137613greatly
greats76318393greats
greave104611493greave
greedy11518853greedy
greeny104811453greeny
grey85624043gre__y
greyly13316543greyly
grimy114312603gr_imy
heady125117263_heady
heapy135914983_heapy
heavy144814183_heavy
infamy1435653infamy
jemmy19498553_jemmy
leady95618603_leady
leafy116316213_leafy
leaky125217723_leaky
leary85927383_leary
leavy115715773_leavy
loamy105913343_loamy
mealy104422183_mealy
meany104620483_meany
meaty107021313_meaty
oogamy1235633oogamy
oread64619603orea_d
oreads73915773oreads
peaky145718153_peaky
peaty105725693_peaty
peavy135014843_peavy
praam94815613praam_
praams10459643praams
pram85733493pr_am_
prams96125513pr_ams
pray96331533pr_a_y
preach133613923preach
preachy17307313preachy
preact103220393preact
preamps1336613preamps
prearm104512353prearm
prearms11369173prearms
prebuy1357423prebuy
predry1237873predry
pregame1239553pregame
prelacy1437583prelacy
preman104117453preman
prename11412643prename
prepay13310313prepay
preppy1235523preppy
pretty11510873pretty
prexy174611583pre_xy
prey96228483pre__y
queasy1855173queasy
queazy2743573queazy
racy95825683_r_acy
ram56867273_r_am_
rami66034093_r_ami
rammy124312493_rammy
ramp85934003_r_amp
rams65950773_r_ams
ray66361993_r_a_y
reach105123883_reach
react74634333_react
read55942533_rea_d
readd74617133_readd
reads64835273_reads
real45750293_rea_l
really93315613_really
realm75621623_realm
realms84913493_realms
reals55038653_reals
realty92713693_realty
reamed94326123_reamed
reamer84325213_reamer
reap65934743_rea_p
reaps75626193_reaps
rear45644553_rea_r
rearm75923573_rearm
rearms85114653_rearms
rears54739653_rears
reata54225393_reata
reave84528023_reave
rebuy104714683_rebuy
redly94217203_redly
redream10107913redream_
redreams1195953redreams
redreamt11127183redreamt
redry94314363_redry
reedy910020293_reedy
reefy114217703_reefy
reeky125416263_reeky
refly113914563_refly
refry114412463_refry
regma84612333_regma
reify114814973_reify
rekey124014733_rekey
relay84424673_relay
rely75428953_re_ly
rem56150043_re_m_
reman75730153_reman
remap95418103_remap
rems66237723_re_ms
rename82718813_rename
repay104818453_repay
reply104015853_reply
resay85320543_resay
retry84718083_retry
revamp1336013_revamp
rheumy1433353rheumy
rimy96621283_r_imy
roam67132413_roam_
roams74919613_roams
roomy107118063_roomy
rummy124212413_rummy
screaky16436223screaky
scream104814253scream_
screams114810623screams
seam66645973_seam_
seams75731663_seams
sleazy18267393sleazy
smeary114110803smeary
sneaky13427843sneaky
steady103510203steady
steam76322933steam_
steams84916903steams
stemmy13417033stemmy
streaky14447813streaky
stream84717293stream_
streams94713373streams
swamy136714403_swamy
sweaty123710053sweaty
team66238653_team_
teams75726513_teams
teary85124053_teary
thready14435903thready
tram67034553tr_am_
tramp96319773tr_amp
trampy13499253tr_ampy
trams75327673tr_ams
tray77632593tr_a_y
treacly1237093treacly
tread64821703trea_d
treads74817923treads
treat56240353trea_t
treats64821693treats
trebly1138973trebly
trendy10469603trendy
tressy9448553tressy
trey77228793tre__y
tweaky1634023tweaky
undreamt1156543undreamt
uneasy9278853uneasy
unready11215943unready
urea46528063urea__
ureal56722683urea_l
ureas55826013urea_s
urease64516993urease
vealy115817773_vealy
weary115620613_weary
wreak125513273wrea_k
wreaks134711113wreaks
wreath124111193wreath
wreathy16326063wreathy

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 Limit1127164405.51620434.4
3Display Results4404400.1403142.9
 (SQL Overall)1786914406.02929638.6
 
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.