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 “amp” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

328 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
amp7754102(None) 
alp56641131alp
am411875561am_
ama510853301ama
ami56646801ami
amps86230341amps
amu58237321amu
app76827601app
asp57235341asp
camp106336451camp
damp96228841damp
gamp98833211gamp
imp76626961imp
lamp86233821lamp
map77255111map
ramp85934001ramp
samp85733591samp
tamp86133001tamp
ump76130441ump
vamp115521541vamp
aa219179952a_a
aah616252962aah
aal39058672aal
aas310975392aas
ab410674762a_b
aba512850952aba
abamp11310602abamp
abo59045962abo
abs59356072abs
aby810238062aby
ace59656832ace
acme86924322acme
act59557842act
ad311975032a_d
add510132362add
ado49146872ado
ads49755732ads
adz1312332862adz
ae212590292a_e
aff95537612aff
aft66849012aft
ag311067462a_g
aga410447232aga
age47154332age
agma77623262agma
ago48845522ago
ags47551662ags
ah513868792a_h
aha611246642aha
ahi68040232ahi
ahs68644822ahs
ai211288392a_i
aid49269072aid
ail37171042ail
aim57858212aim
aims67738182aims
ain37579092ain
air38058392air
ais39083572ais
ait38093902ait
al210674042a_l
ala312463602ala
alb57342652alb
ale36572342ale
all36148232all
alma66333022alma
alme65832162alme
alms65834922alms
alps65529242alps
als36663022als
alt36467962alt
amah98927482amah
amas67746292amas
ambo88225132ambo
amen66733152amen
amia66836892amia
amid77036332amid
amie66339842amie
amin66042242amin
amir65129742amir
amis66445312amis
ammo85520132ammo
amok10217402amok
amped104820512amped
ample94720302ample
amply125012912amply
ampul91110852ampul
amus65529612amus
amyl95515092amyl
an211879072a_n
ana39559822ana
and47244162and
ane37866942ane
ani37751172ani
ant37270782ant
any68440482any
ape57251182ape
apo511142122apo
apps86319692apps
apt57352542apt
ar211379382a_r
arb510448422arb
arc510250902arc
are37874572are
arf67453372arf
ark77044962ark
arm58449622arm
arms66137492arms
army96624182army
ars37670932ars
art38679142art
as211083072a_s
ash67944602ash
ask77130702ask
asps65622092asps
ass37844062ass
at212393402a_t
atap66722452atap
ate37059242ate
atma68121772atma
atop66124752atop
att35454652att
auk76234142auk
ava610139322ava
ave67748702ave
avo68936232avo
aw512563402a_w
awa611939672awa
awe67746622awe
awl67635302awl
awn68035912awn
ax911057782a_x
axe108239492axe
ay511773892a_y
aye67151762aye
ays67050292ays
azo128233392azo
bam78560142bam_
bams87044452bams
bap76455842bap
bop77549482bop
bump106228242bump
cam78058982cam_
came87648752came
camo85731752camo
campi116217782campi
campo115219762campo
camps116330262camps
campy145116182campy
cams87047282cams
cap76758982cap
carp85139812carp
cep75736332cep
champ145017962champ
clamp115517652clamp
comp106731252comp
cop711162372cop
cramp115120692cramp
cup76738242cup
dam67457042dam_
dame77140312dame
damn75724322damn
damps105220412damps
dams77444372dams
dap66652452dap
dip67848982dip
dump95927092dump
dup67637882dup
em49445152em_
eme55837182eme
ems56435492ems
emu55929982emu
fame95639392fame
fop86743702fop
gam67060062gam_
gama77035512gama
gamb96331842gamb
game76644322game
gamps105323712gamps
gams76648882gams
gamy105427532gamy
gap67055612gap
gasp76227332gasp
gawp107618632gawp
gimp96124042gimp
gip67645362gip
gramp106218322gramp
gyp98319012gyp
ham86363282ham_
hame97043132hame
hams96446132hams
hap87360052hap
harp96134282harp
hasp96627292hasp
hemp115725622hemp
hep86644142hep
hip86750432hip
hm78126732hm_
hmm106218992hmm
hop87554592hop
hump116228722hump
hup86437812hup
hyp117822462hyp
iamb86623722iamb
impi85415772impi
imps86221112imps
jam126942522jam_
jamb155523852jamb
jams135231072jams
jaup135316422jaup
jimp155618462jimp
jump156621722jump
kame105728232kame
kami105823642kami
kemp126418762kemp
kep96437202kep
kip97042132kip
kop97440202kop
lam57666712lam_
lama66635292lama
lamb86832142lamb
lame66849292lame
lamps95624832lamps
lams66552262lams
lap58565272lap
limp88432492limp
lip514755802lip
lop58255312lop
lump86531702lump
ma410060652_ma
mac78053922mac
mad68958702mad
mae57659102mae
mag67956472mag
mama86231582mama
man57465852man
maps86141042maps
mar57965942mar
mas58175812mas
mat58083932mat
maw87050092maw
max129045442max
may88757622may
me47748332_me
mi48249042_mi
mm67826812_mm
mo49158482_mo
mop76950822mop
mu46737482_mu
mump105425722mump
my78125652_my
nam55953392nam_
name65637412name
nap56753202nap
nip56945982nip
om48553002om_
oms56337512oms
op45850162_op
palp85828572palp
pam77858392pam_
pampa114913422pampa
pams85641762pams
pap76758402pap
pep76447082pep
pimp106024902pimp
pip78051042pip
pomp106225462pomp
pop76252252pop
pump105726852pump
pup76339882pup
ram56867272ram_
rami66034092rami
ramps96224632ramps
rams65950772rams
rap56261962rap
rasp66029162rasp
rep55847802rep
rip56851302rip
romp85926572romp
rump86729082rump
salp64534092salp
same65245642same
samps96124672samps
sap56463232sap
scamp115717312scamp
simp85228772simp
sip57656012sip
sop57557862sop
stamp95217362stamp
sump86331532sump
sup57041942sup
swamp125015322swamp
tam58663422tam_
tame66343662tame
tamps95524082tamps
tams67247932tams
tap57663872tap
tarp66936412tarp
temp85323332temp
tip56551222tip
top510560682top
tramp96319772tramp
tump85927032tump
tup56037542tup
um47338832um_
umm711921262umm
umps85721942umps
up47832822_up
urp56426392urp
vamps125415482vamps
vampy15539402vampy
wame95035482wame
wap86553372wap
warp95635002warp
wasp95626852wasp
wimp115521522wimp
wop87145132wop
yam87448992yam_
yams95330732yams
yap85949822yap
yaup96618482yaup
yawp125215582yawp
yep86638962yep
yip87241172yip
yup86031702yup
zap145840692zap
zep147129142zep
zip146636222zip

Search took 1 second 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 Filter178691140840.0602978183.3
2DLD Change Limit140843280.40634689.7
3Display Results3283280.0635206.3
 (SQL Overall)1786913280.529337790.2
 
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.