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

411 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
dreamt9461571(None) 
dream85120391dream_
dreams94513981dreams
dreamy12509991dreamy
bream95121812bream_
breams104815042breams
breast8319632breast
cream95721352cream_
creams104715252creams
creamy134811362creamy
dealt65234282d_ealt
derat65044082dera_t
draft95526682dr_aft
dram75832002dr_am_
drama85117422dr_ama
drams86025832dr_ams
drat56247832dr_a_t
dread74419022drea_d
dreads84115022dreads
dreamed114310632dreamed
dreamer104110842dreamer
drear65016902drea_r
drears74614252drears
dreary104611672dreary
drest65530342dre_st
great66034242grea_t
preact103220392preact
preamp1238992preamp
react74634332_react
ream65841612_ream_
reams75729622_reams
redreamt11127182redreamt
treat56240352trea_t
undreamt1156542undreamt
abeam9316533abeam_
abreact11310823abreact
abreast9311273abreast
arame75026623ar_ame
area45843393area__
areae55229743area_e
areal55928733area_l
areas55935773area_s
arhat8327093arha_t
arrant6623253arrant
beam86939233_beam_
beams95328173_beams
beamy126218573_beamy
beast76338643_beast
beat66168303_bea_t
beaut75135213_beaut
bleat75737003blea_t
bract96332723br_act
brant74742173br_ant
brat66055543br_a_t
breach134213723breach
bread85523113brea_d
breads95419203breads
breadth1365993breadth
bready124511183bready
break115319403brea_k
breaks124816423breaks
breamed124011593breamed
breasts939703breasts
breath113916263breath
bregma1134963bregma
brent75734133bre_nt
brevet115717333brevet
cheat105732453chea_t
cleat76335063clea_t
craft105327663cr_aft
cram85635493cr_am_
cramp115120693cr_amp
crams96229153cr_ams
creak115418433crea_k
creaks124315963creaks
creaky154911553creaky
creamed123913713creamed
creamer113714093creamer
crease85519573crease
creasy114612303creasy
create85126383create
credit9315193credit
cremate113816183cremate
creme94319323cre_me
crept95125893cre_pt
crest74632693cre_st
daft85537253d__aft
dam67457043d__am_
dame77140313d__ame
damn75724323d__amn
damp96228843d__amp
dams77444373d__ams
dart55857873d__art
daut56443563d__aut
dawt85435943d__awt
daydreamt1652433daydreamt
dead65434243d_ea_d
deads75726913d_eads
deaf85838403d_ea_f
deair65817193d_eair
deal56347413d_ea_l
deals65435343d_eals
dean56039483d_ea_n
deans66131393d_eans
dear55343603d_ea_r
dears65736883d_ears
dearth104212513d_earth
deary95826843d_eary
deash95617243d_eash
death94822523d_eath
deave95022333d_eave
debit85727853d_ebit
debt77139023d_e_bt
debut86024143d_ebut
decamp1338453decamp
decant93524223decant
deem75432893d_eem_
deems85421773d_eems
deet57356583d_e_et
defame123212433defame
defat95426693d_efat
defeat103817163defea_t
deft85540223d_e_ft
degame102713183degame
degami10279013degami
deist64633593d_eist
delft95623323d_elft
delt57855273d_e_lt
demast9517063demast
deme76536283d_e_me
demit84832303d_emit
demo77427553d_e_mo
demy105422853d_e_my
dent57158413d_e_nt
depart94720563depart
depot85727923d_epot
derail74218813derail
derate74531233derate
derats74625063derats
deray95024183dera_y
derays105514253derays
derm76031893d_erm_
derma84918513d_erma
dermal93614343dermal
dermas94116813dermas
derms85022893d_erms
desalt7518313desalt
dicast9315573dicast
didact10711203didact
diet57357533die__t
digamy1335893digamy
diram84419473diram_
dirams94413703dirams
direct93817333dire_ct
direst75024243dire_st
dirham12378273dirham_
dirhams13376313dirhams
doat56947673d_oa_t
doest65829523doe_st
dopant9316133dopant
dormant102814373dormant
drab76226453dr_a_b
drabs85119673dr_abs
draff125615663dr_aff
drafts105012533dr_afts
drafty13638933dr_afty
drag64825053dr_a_g
drags75521113dr_ags
drail65020973dr_ail
drain65222893dr_ain
drake104918303dr_ake
dramas95814663dr_amas
drank104816203dr_ank
drape85319633dr_ape
drats66628373dr_ats
drave95219273dr_ave
draw85623013dr_a_w
drawl95516013dr_awl
drawn95614243dr_awn
draws95119373dr_aws
dray85428093dr_a_y
drays95819773dr_ays
dreaded103612023dreaded
dreamboat1472973dreamboat
dreamers11369003dreamers
dreamful1452963dreamful
dreamier11287293dreamier
dreamiest12227223dreamiest
dreamily1435143dreamily
dreaming124011063dreaming
dreamtime1442343dreamtime
dreck124812803dre_ck
drecks13459203drecks
drecky16486333drecky
dredge9308563dredge
dree56638323dre__e
dreed75222843dre_ed
drees65628523dre_es
dreg66821653dre__g
dreggy12364633dreggy
dregs76114863dre_gs
dreich12377723dreich
dreidl835233dreidl
dreigh11246443dreigh
drek96321093dre__k
dreks105714753dre_ks
drench12369593drench
dress65319833dre_ss
dressy10518143dressy
drew86221673dre__w
driest74722753driest
drift95722843dr_ift
dript86923873dr_ipt
droit65127123dr_oit
dropt86924433dr_opt
drum76521593dr_um_
drums85415873dr_ums
dryad10477583drya_d
dryads11436623dryads
dryest104811123dryest
drylot1037403drylot
ducat86225903duca_t
duet56446263due__t
dunam8313733dunam_
dunams937833dunams
durmast1037623durmast
dwelt94316523dwe_lt
dynamo1274163dynamo
dynast1088223dynast
east46659103__east
eat36989053__ea_t
erect74129333ere_ct
errant6618733errant
feast85932723_feast
feat76458223_fea_t
fleam106017283fleam_
fleams115011943fleams
frame105821803fr_ame
frat75648543fr_a_t
freak125115243frea_k
freaks134713063freaks
freaky16439233freaky
freest95318283freest
fremd115010323fre_md
fret75845043fre__t
gleam86916733gleam_
gleams94812253gleams
gleamy12398113gleamy
graft95327203gr_aft
gram77034583gr_am_
grama85620283gr_ama
gramp106218323gr_amp
grams85327313gr_ams
grant64840023gr_ant
grat55651283gr_a_t
grease75416233grease
greasy10419463greasy
greats76318393greats
greave104611493greave
greet65835323gre_et
gremmy1454473gremmy
groat65531973groa_t
heart85440743_heart
heat77061423_hea_t
hereat93527413herea_t
kraft125721013kr_aft
krait94726773kr_ait
kraut95221403kr_aut
leant56737783_leant
leapt75027473_leapt
least56134883_least
meant76537213_meant
meat66359603_mea_t
neat46356783_nea_t
oread64619603orea_d
oreads73915773oreads
orgeat7515033orgea_t
outdreamt1244203outdreamt
peart76440753_peart
peat65967933_pea_t
pleat74734473plea_t
praam94815613praam_
praams10459643praams
pram85733493pr_am_
prams96125513pr_ams
prat65952043pr_a_t
preach133613923preach
preacts113211363preacts
preadmit1346813preadmit
preamps1336613preamps
prearm104512353prearm
prearms11369173prearms
precast11314853precast
precut102016533precut
preempt1337723preempt
pregame1239553pregame
preman104117453preman
prename11412643prename
preset84430983preset
prest75736353pre_st
raft76245913_r_aft
ram56867273_r_am_
ramet75743143_r_amet
rami66034093_r_ami
ramp85934003_r_amp
rams65950773_r_ams
rant45864683_r_ant
rapt67245313_r_apt
rat37892743_r_a_t
reach105123883_reach
reacts83616603_reacts
read55942533_rea_d
readd74617133_readd
readmit1039823_readmit
reads64835273_reads
ready94821503_ready
real45750293_rea_l
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
rebait8320403_rebait
rebut75927383_rebut
recant83228683_recant
recast83422773_recast
recit75235103_recit
recut74729243_recut
redact9419043_redact
redream10107913redream_
redreams1195953redreams
reemit8717223_reemit
reest54938093_reest
refit84230063_refit
reft75141273_re_ft
regma84612333_regma
relet54749823_relet
relit55340683_relit
rem56150043_re_m_
reman75730153_reman
remap95418103_remap
remate84428683_remate
remet74843723_remet
remit75737223_remit
rems66237723_re_ms
rename82718813_rename
rent46661243_re_nt
repast83520633_repast
repot75132623_repot
resat55139683_resat
reset55051863_reset
resit54241043_resit
rest46459843_re_st
ret35982833_re__t
revamp1336013_revamp
revet84938843_revet
rewet85135153_rewet
riant55833153_riant
roam67132413_roam_
roams74919613_roams
roast56230143_roast
scream104814253scream_
screams114810623screams
seam66645973_seam_
seams75731663_seams
seamy105921273_seamy
seat47575563_sea_t
steam76322933steam_
steams84916903steams
steamy115112373steamy
stream84717293stream_
streams94713373streams
streamy12509483streamy
sweat85628403swea_t
team66238653_team_
teams75726513_teams
teat45963633_tea_t
threat95020463threa_t
tract75635713tr_act
trait56940843tr_ait
tram67034553tr_am_
tramp96319773tr_amp
trams75327673tr_ams
trapt76433393tr_apt
tread64821703trea_d
treads74817923treads
treats64821693treats
treaty94414353treaty
tret46653533tre__t
trevet94818913trevet
truant6315783truant
urea46528063urea__
ureal56722683urea_l
ureas55826013urea_s
urease64516993urease
wheat114924573whea_t
wrapt105123183wr_apt
wreak125513273wrea_k
wreaks134711113wreaks
wreath124111193wreath
wrest84925433wre_st
yeast85327943_yeast

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 Filter1786911127160.390458182.1
2DLD Change Limit1127164116.73316740.8
3Display Results4114110.1402935.7
 (SQL Overall)1786914117.26324602.9
 
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.