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

321 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
preamps133661(None) 
preamp1238991preamp_
breams104815042bream_s
cramps125615562cr_amps
creams104715252cream_s
dreams94513982dream_s
gramps114114272gr_amps
praams10459642praam_s
prams96125512pr_am_s
preacts113211362preacts
prearms11369172prearms
preempt1337722preempt
preempts1444542preempts
pregames1339002pregames
prenames12311642prenames
preops104911942pre_ops
preps96220692pre__ps
prestamps1543522prestamps
primps124711822pr_imps
ramps96224632_r_amps
reams75729622_ream_s
reaps75626192_rea_ps
remaps105012872_remaps
revamps1433992_revamps
tramps105114452tr_amps
abamps1236253_abamps
amps86230343___amps
arames84622573ar_ames
areas55935773area__s
beams95328173_beam_s
breads95419203brea_ds
breaks124816423brea_ks
breakups1642513breakups
bream95121813bream__
breamed124011593breamed
breasts939703breasts
breaths124411183breaths
camps116330263__camps
champs154915683_champs
cheaps134613683chea_ps
clamps124515083_clamps
cramp115120693cr_amp_
crampy154710993cr_ampy
crams96229153cr_am_s
craps95328643cr_a_ps
creaks124315963crea_ks
cream95721353cream__
creamcups1741343creamcups
creamed123913713creamed
creamer113714093creamer
creamers124111313creamers
creamy134811363cream_y
creases94020963creases
creates95225203creates
creeps104213623cre_eps
cremes104517993cre_mes
crimps124613453cr_imps
crumps124514343cr_umps
damps105220413__damps
decamps1435643decamps
dramas95814653dr_amas
drams86025833dr_am_s
dreads84115023drea_ds
dream85120393dream__
dreamed114310633dreamed
dreamer104110843dreamer
dreamers11369003dreamers
dreamt94615713dream_t
dreamy12509993dream_y
drears74614253drea_rs
encamps1335423encamps
firedamps1742843firedamps
fleams115011943fleam_s
frames115119863fr_ames
fraps105620553fr_a_ps
freaks134713063frea_ks
frumps13479783fr_umps
gamps105323713__gamps
gleams94812253gleam_s
gramas94317203gr_amas
gramp106218323gr_amp_
grampa115010173gr_ampa
grampas12399253gr_ampas
grampus12356313gr_ampus
grams85327313gr_am_s
grasps9489253gr_asps
greases84816713greases
greats76318393grea_ts
greaves113311443greaves
grumps114510573gr_umps
heaps105223223_hea_ps
hemps126917333_he_mps
kemps135012523_ke_mps
kreeps12427413kre_eps
lamps95624833__lamps
leaps75522933_lea_ps
neaps75618323_nea_ps
oreads73915773orea_ds
paeans85118263paea_ns
pajamas18278153pajamas
palps94719563p__alps
pampa114913423p__ampa
pampas124913993p__ampas
pams85641763p__am_s
panamas113112763panamas
paps86443453p__a_ps
paramos113213513paramos
peaces106324083p_eaces
peages94321853p_eages
peags86122843p_ea_gs
peaks114825623p_ea_ks
peals75235493p_ea_ls
peans75437643p_ea_ns
pearls84715393p_earls
pears75138613p_ea_rs
peas65755063p_ea__s
peases85229473p_eases
peats76140193p_ea_ts
peeps95822363p_e_eps
peps85134513p_e__ps
perhaps1446123perhaps
perms95524513p_erm_s
perps95521483p_e_rps
phreaks1634543phrea_ks
pimps114616983p__imps
pleads94613953plea_ds
pleas75627033plea__s
pleases94515483pleases
pleats85218593plea_ts
plumps124612613p_lumps
pneumas1145103pneumas
poems95715553poe_m_s
pomps115316193p__omps
praam94815613praam__
prahus11458243pr_ahus
pram85733493pr_am__
prangs94816233pr_angs
pranks124814723pr_anks
praos74923563pr_a_os
prases84429023pr_ases
prates84633163pr_ates
prats76333393pr_a_ts
praus74621753pr_a_us
prawns11509023pr_awns
praxes156215183pr_axes
praxis154012253pr_axis
prays105022433pr_a_ys
preach133613923prea_ch
preaches153214893preaches
preachy17307313preachy
preact103220393prea_ct
preadapt1346863preadapt
preadapts1444003preadapts
preadmit1346813preadmit
preadmits1444923preadmits
preadopt1348313preadopt
preadopts1445143preadopts
preaged11612333preaged
preamble1436383preamble
preambles1545333preambles
preanal9310713preanal
preapply1443303preapply
prearm104512353prea_rm
prearmed1397993prearmed
preaver121011613preaver
preavers13910263preavers
prebakes1639013prebakes
prebids12399883prebids
prebuys1444393prebuys
precasts1239453precasts
precept133112513precept
precepts14268893precepts
precess11310863precess
precipe133012123precipe
precipes143212213precipes
precis103416703pre_cis
precuts111710473precuts
predates11615813predates
predawns1444363predawns
preemie11310563preemie
preemies12512193preemies
preens85020113pre_ens
prees75937173pre__es
prefabs1435163prefabs
prefaces15311063prefaces
prefades1439533prefades
prefers123713333prefers
pregame1239553pregam_e
preimpose1544013preimpose
prelates10418573prelates
prelims1139823prelims
premade12311443premade
preman104117453pre_man
premed114617763pre_med
premeds12389593premeds
premen105017803pre_men
premie103617993pre_mie
premies113823063premies
premise113818553pre_mise
premiss113513813premiss
premix173710333pre_mix
prename11412643prenam_e
preop94715873pre_op_
prep86427673pre__p_
prepacks1836583prepacks
prepares122014163prepares
prepaves15189193prepaves
prepays1437483prepays
preppy1235523pre_ppy
prepupa1064023prepupa
prepupas1144133prepupas
presages11312203presages
presales10315263presales
presets94216423presets
preships1539313preships
press75425953pre__ss
presses93523153presses
prestamp1445323prestamp_
prestos93716083prestos
prests84021263pre_sts
presumes1239843presumes
pretape113511623pretape
pretapes122811533pretapes
pretors9316813pretors
pretype14387483pretype
pretypes15337263pretypes
prevails1337663prevails
prevues1239263prevues
prewarms15406733prewarms
prewarns13456943prewarns
prewraps15114053prewraps
prexes154915953pre_xes
prexies163415003prexies
preyers124412363preyers
preys105717783pre__ys
prezes173614693pre_zes
priapi1037923pria_pi
priapus1134353priapus
primas104418103pr_imas
primes104225263pr_imes
primos104514423pr_imos
primp115615923pr_imp_
prims95425933pr_im_s
primus103712173pr_imus
prisms104915503prism_s
proas75028803proa__s
procarps1445973procarps
proems104711163proem_s
promos105116423pr_omos
prompt12313013pr_ompt
prompts1337473pr_ompts
proms95426413pr_om_s
props95726883pr__ops
pumps115520603p__umps
pyjamas21263523pyjamas
ramp85934003_r_amp_
rams65950773_r_am_s
ramus76418283_r_amus
raps66247733_r_a_ps
rasps74316663_r_asps
reacts83616603_reacts
readds84111643_readds
reads64835273_rea_ds
reales64934123_reales
realms84913493_realms
reals55038653_rea_ls
ream65841613_ream__
reamed94326123_reamed
reamer84325213_reamer
reamers94221083_reamers
reap65934743_rea_p_
rearms85114653_rearms
rears54739653_rea_rs
reatas64021013_reatas
reaves94127573_reaves
rebops10311433_rebops
recaps103615733_recaps
redips93713843_redips
remans84823003_remans
remap95418103_remap_
rems66237723_re_m_s
renames92418053_renames
repps95114343_re_pps
reps65937953_re__ps
repumps1334403_repumps
restamps1234703_restamps
revamp1336013_revamp_
roams74919613_roam_s
romps94617543_r_omps
rumps95922293_r_umps
samps96124673__samps
scamps125014173_scamps
screams114810623scream_s
seams75731663_seam_s
sneaps84510863snea_ps
spreads1039763sprea_ds
stamps105614023_stamps
steams84916903steam_s
streams94713373stream_s
swamps135910263_swamps
tamps95524083__tamps
teams75726513_team_s
temps95417133_te_mps
threaps12488643threa_ps
tramp96319773tr_amp_
trampy13499253tr_ampy
trams75327673tr_am_s
traps75727483tr_a_ps
treads74817923trea_ds
treats64821693trea_ts
tromps104911703tr_omps
trumps104611883tr_umps
upheaps1494233uphea_ps
upleaps1185233uplea_ps
uprears9107493uprea_rs
ureas55826013urea__s
ureases74416723ureases
vamps125415483__vamps
wraps105617153wr_a_ps
wreaks134711113wrea_ks
wreaths13338373wreaths

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 Filter1786911340270.406440125.6
2DLD Change Limit1340273216.86019537.5
3Display Results3213210.1232609.8
 (SQL Overall)1786913217.38924183.4
 
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.