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

409 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
preamp123899(None) 
preamps1336611preamps
bream95121812bream_
breams104815042breams
cramp115120692cr_amp
cream95721352cream_
creams104715252creams
creamy134811362creamy
dream85120392dream_
dreams94513982dreams
dreamt94615712dreamt
dreamy12509992dreamy
gramp106218322gr_amp
praam94815612praam_
praams10459642praams
pram85733492pr_am_
prams96125512pr_ams
preach133613922preach
preact103220392preact
prearm104512352prearm
prearms11369172prearms
preempt1337722preempt
pregame1239552pregame
preman104117452preman
prename11412642prename
preop94715872pre_op
prep86427672pre__p
prestamp1445322prestamp
primp115615922pr_imp
ramp85934002_r_amp
ream65841612_ream_
reams75729622_reams
reap65934742_rea_p
remap95418102_remap
revamp1336012_revamp
tramp96319772tr_amp
abamp11310603_abamp
abeam9316533abeam_
amp77541023___amp
arame75026623ar_ame
area45843393area__
areae55229743area_e
areal55928733area_l
areas55935773area_s
beam86939233_beam_
beams95328173_beams
beamy126218573_beamy
breach134213723breach
bread85523113brea_d
breads95419203breads
bready124511183bready
break115319403brea_k
breaks124816423breaks
breakup1543463breakup
breamed124011593breamed
breast8319633breast
breath113916263breath
bregma1134963bregma
camp106336453__camp
champ145017963_champ
cheap126915943chea_p
clamp115517653_clamp
cram85635493cr_am_
cramps125615563cr_amps
crampy154710993cr_ampy
crams96229153cr_ams
crap85731843cr_a_p
creak115418433crea_k
creaks124315963creaks
creaky154911553creaky
creamed123913713creamed
creamer113714093creamer
crease85519573crease
creasy114612303creasy
create85126383create
creep95218103cre_ep
creme94319323cre_me
crimp115615803cr_imp
crump115616423cr_ump
damp96228843__damp
decamp1338453decamp
dram75832003dr_am_
drama85117413dr_ama
drams86025833dr_ams
dread74419023drea_d
dreads84115023dreads
dreamed114310633dreamed
dreamer104110843dreamer
drear65016903drea_r
drears74614253drears
dreary104611673dreary
encamp1235943encamp
firedamp1643743firedamp
fleam106017283fleam_
fleams115011943fleams
frame105821803fr_ame
frap95925813fr_a_p
freak125115243frea_k
freaks134713063freaks
freaky16439233freaky
fremd115010323fre_md
frump126912563fr_ump
gamp98833213__gamp
gleam86916733gleam_
gleams94812253gleams
gleamy12398113gleamy
gram77034583gr_am_
grama85620283gr_ama
grampa115010173gr_ampa
gramps114114273gr_amps
grams85327313gr_ams
grasp84814483gr_asp
grease75416233grease
greasy10419463greasy
great66034243grea_t
greats76318393greats
greave104611493greave
gremmy1454473gremmy
grump105115313gr_ump
heap96432893_hea_p
hemp115725623_he_mp
kemp126418763_ke_mp
kreep114610413kre_ep
lamp86233823__lamp
leap66032683_lea_p
neap66927013_nea_p
oread64619603orea_d
oreads73915773oreads
paean77222723paea_n
paeans85118263paeans
pajama17317653pajama
palp85828573p__alp
pam77858393p__am_
pampa114913423p__ampa
pams85641763p__ams
panama104213353panama
pap76758403p__a_p
paramo102614643paramo
pea56657243p_ea__
peace95026083p_eace
peach125422493p_each
peag75431343p_ea_g
peage84723573p_eage
peags86122843p_eags
peak106535203p_ea_k
peaks114825623p_eaks
peaky145718153p_eaky
peal68648103p_ea_l
peals75235493p_eals
pean66147173p_ea_n
peans75437643p_eans
pear69745233p_ea_r
pearl75324463p_earl
pears75138613p_ears
peart76440753p_eart
peas65755063p_ea_s
pease75231113p_ease
peat65967933p_ea_t
peats76140193p_eats
peaty105725693p_eaty
peavy135014843p_eavy
peep85833693p_e_ep
pep76447083p_e__p
perea75026443perea__
perm85834633p_erm_
perms95524513p_erms
perp89029893p_e_rp
phreak1536153phrea_k
phreaks1634543phreaks
pimp106024903p__imp
plea66830603plea__
pleach134211243pleach
plead85818463plea_d
pleads94613953pleads
pleas75627033plea_s
please84315733please
pleat74734473plea_t
pleats85218593pleats
plump115315263p_lump
pneuma1035263pneuma
poem86225773poe_m_
poems95715553poe_ms
pomp106225463p__omp
prahu105013973pr_ahu
prang84820323pr_ang
prank115019453pr_ank
prao66229023pr_a_o
praos74923563pr_aos
prase76128753pr_ase
prat65952043pr_a_t
prate75135983pr_ate
prats76333393pr_ats
prau66529473pr_a_u
praus74621753pr_aus
prawn105312433pr_awn
pray96331533pr_a_y
prays105022433pr_ays
preachy17307313preachy
preacts113211363preacts
preadapt1346863preadapt
preadmit1346813preadmit
preadopt1348313preadopt
preaged11612333preaged
preamble1436383preamble
preanal9310713preanal
preapply1443303preapply
prearmed1397993prearmed
preaver121011613preaver
prebade12310283prebade
prebake1539093prebake
prebid113512843prebid
prebuy1357423prebuy
precast11314853precast
precava1445093precava
precept133112513precept
precipe133012123precipe
precis103416703precis
precoup1336123precoup
precut102016533precut
predate10616893predate
predawn1335353predawn
predry1237873predry
pree67044733pre__e
preed85128123pre_ed
preemie11310563preemie
preempts1444543preempts
preen75925053pre_en
preens85020113preens
prees75937173pre_es
prefab1336243prefab
prefabs1435163prefabs
preface14510923preface
prefade1339013prefade
prefer113813203prefer
prefix18356853prefix
preflame1545913preflame
pregames1339003pregames
prelacy1437583prelacy
prelate9519693prelate
prelaw1139103prelaw
prelim10311423prelim
prelims1139823prelims
premade12311443premade
premed114617763premed
premen105017803premen
premie103617993premie
premix173710333premix
prenames12311643prenames
preops104911943preops
prepack1757643prepack
prepaid12310133prepaid
prepare111913623prepare
prepave14228873prepave
prepay13310313prepay
prepays1437483prepays
preppy1235523preppy
preps96220693pre_ps
prepupa1064023prepupa
prerace11414123prerace
presa74319043pre_sa
presage10312293presage
presale9416353presale
prese75228383pre_se
preset84430983preset
preship1439793preship
press75425953pre_ss
prest75736353pre_st
prestamps1543523prestamps
presto84216203presto
prests84021263prests
presume11310303presume
pretape113511623pretape
pretax152310193pretax
pretor8315753pretor
pretty11510873pretty
pretype14387483pretype
prevail1238243prevail
prevue1179163prevue
prewar114712583prewar
prewarm14479613prewarm
prewarms15406733prewarms
prewarn124410153prewarn
prewash1535213prewash
prewrap14104973prewrap
prex135722973pre__x
prexes154915953prexes
prexy174611583pre_xy
prey96228483pre__y
preyed125313203preyed
preyer114413733preyer
preys105717783pre_ys
prez156126313pre__z
prezes173614693prezes
priapi1037923priapi
prim85132203pr_im_
prima95019343pr_ima
primal104014623primal
primas104418103primas
prime96525603pr_ime
primi95017403pr_imi
primo95017913pr_imo
primps124711823pr_imps
prims95425933pr_ims
prism94820263prism_
prisms104915503prisms
proa66229963proa__
proas75028803proa_s
procarp1346823procarp
proem94818273proem_
proems104711163proems
prom87631703pr_om_
promo95620003pr_omo
prompt12313013pr_ompt
proms95426413pr_oms
prop85932813pr__op
pump105726853p__ump
pyjama20303483pyjama
ram56867273_r_am_
rami66034093_r_ami
ramps96224633_r_amps
rams65950773_r_ams
rap56261963_r_a_p
rasp66029163_r_asp
reach105123883_reach
react74634333_react
read55942533_rea_d
readd74617133_readd
reads64835273_reads
ready94821503_ready
real45750293_rea_l
realm75621623_realm
realms84913493_realms
reals55038653_reals
reamed94326123_reamed
reamer84325213_reamer
reaps75626193_reaps
rear45644553_rea_r
rearm75923573_rearm
rearms85114653_rearms
rears54739653_rears
reata54225393_reata
reave84528023_reave
rebop9313283_rebop
recap95718023_recap
redip87816963_redip
regma84612333_regma
rem56150043_re_m_
reman75730153_reman
remaps105012873_remaps
rems66237723_re_ms
rename82718813_rename
rep55847803_re__p
repp85418743_re_pp
repump1235683_repump
restamp1146483_restamp
revamps1433993_revamps
roam67132413_roam_
roams74919613_roams
romp85926573_r_omp
rump86729083_r_ump
samp85733593__samp
scamp115717313_scamp
scream104814253scream_
screams114810623screams
seam66645973_seam_
seams75731663_seams
seamy105921273_seamy
sneap75514823snea_p
spread9312533sprea_d
spreads1039763spreads
stamp95217363_stamp
steam76322933steam_
steams84916903steams
steamy115112373steamy
stream84717293stream_
streams94713373streams
streamy12509483streamy
swamp125015323_swamp
tamp86133003__tamp
team66238653_team_
teams75726513_teams
temp85323333_te_mp
threap11569663threa_p
tram67034553tr_am_
tramps105114453tr_amps
trampy13499253tr_ampy
trams75327673tr_ams
trap67532803tr_a_p
tread64821703trea_d
treads74817923treads
treat56240353trea_t
treats64821693treats
treaty94414353treaty
tromp95815803tr_omp
trump95615123tr_ump
upheap13105213uphea_p
upleap10106843uplea_p
upreach1444693upreach
uprear8168793uprea_r
uprears9107493uprears
urea46528063urea__
ureal56722683urea_l
ureas55826013urea_s
urease64516993urease
vamp115521543__vamp
wrap96821973wr_a_p
wreak125513273wrea_k
wreaks134711113wreaks
wreath124111193wreath

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.750238254.7
2DLD Change Limit1127164096.81016551.5
3Display Results4094090.1263246.0
 (SQL Overall)1786914097.68623248.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.