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

473 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
abamps123625(None) 
abamp11310601abamp_
abacas104414722abacas
abacus10349762abacus
abakas123911742abakas
abas68642082aba__s
abases85720772abases
abates85825032abates
abatis84317932abatis
abayas114011702abayas
abomas101113582abomas
agamas97413442agamas
alamos8415002alamos
amps86230342__amps
arames84622572arames
ataps76414832ata_ps
bams87044452_bam_s
baps86040842_ba_ps
bumps115921142_bumps
camps116330262_camps
champs154915682champs
clamps124515082clamps
cramps125615562cramps
damps105220412_damps
gamps105323712_gamps
gramps114114272gramps
lamps95624832_lamps
ramps96224632_ramps
samps96124672_samps
scamps125014172scamps
stamps105614022stamps
swamps135910262swamps
tamps95524082_tamps
tramps105114452tramps
vamps125415482_vamps
aahs716428563a_a_hs
aals49941143a_a_ls
aas310975393a_a__s
aba512850953aba___
abaca95118043aba_ca
abaci94718843aba_ci
aback134816173aba_ck
abaft10318063aba_ft
abaka114313823aba_ka
abampere1442853abampere
abamperes1563023abamperes
abase76023483aba_se
abased96514993abased
abaser86414343abaser
abasers95311973abasers
abash106016513aba_sh
abashes12510373abashes
abasia8712953abasia
abasias9711013abasias
abate76627843aba_te
abated95918453abated
abater85518123abater
abaters95115193abaters
abator84512713abator
abators94413073abators
abattis9297823abattis
abaya104413173aba_ya
abbas95918643ab_bas
abbes96723523ab_bes
abbess10509773abbess
abbeys13538423abbeys
abbots1039283abbots
abeam9316533abeam__
abeles84719393abeles
abets75621673ab_ets
abhors11410623abhors
abides94719893abides
ablates92416903ablates
ablauts936083ablauts
ables75935543ab_les
ablins8316193ablins
abmho1236793ab_mho
abmhos1334973abmhos
abodes94417513abodes
abohms1335003abohms
aboma91114603abom_a
abomasa11114613abomasa
abomasi11115493abomasi
aborts84916183aborts
abos67734413ab__os
aboves114512843aboves
abrades10312073abrades
abris75722603ab_ris
abrupt1039943abrupt
abs59356073ab___s
abuses85119103abuses
abuts75417073ab_uts
abwatts1233403abwatts
abyes105518533ab_yes
abys97221883ab__ys
abysms13565653abysms
abyss10669463ab_yss
acarus8312193acarus
acmes96020653a_cmes
adages8412953adages
adapt81218553ada_pt
adapts9107813adapts
admass957143admass
afars85716513afa_rs
agama85815573agam_a
agamic113110543agamic
agamid103710673agamid
agamids11317003agamids
agamous1037923agamous
agape85614843aga_pe
agapes95212413agapes
agars66120643aga_rs
agas55938843aga__s
agates76121333agates
agaves104611513agaves
agmas85919873a_gmas
aims67738183a_im_s
alamo7418143alam_o
alands75418373alands
alans55636173ala_ns
alants67722023alants
alarms85913053alarms
alas46358123ala__s
alates64833963alates
albas75925393alba__s
albatas938373albatas
albums10198273album_s
almahs118611613almahs
almas76629773a_lmas
almes75126543a_lmes
alms65834923a_lm_s
alps65529243__alps
alums75720603alum_s
amahs107819063ama_hs
amas67746293__amas
amass77119683ama_ss
amazes175613473amazes
ambages1269623ambages
ambaris113112123ambaris
amis66445323__amis
ammos94815823a_mmos
amp77541023__amp_
amus65529613__amus
anabas8314083anabas
anas46649863ana__s
animas84418723animas
animes84719593animes
animis84615943animis
animus84211613animus
apps86319693__apps
araks94820883ara_ks
arame75026623aram_e
aramid93315603aramid
aramids102810503aramids
arms66137493a_rm_s
aromas81018613aromas
arums75517833arum_s
asanas6514113asanas
asps65622093__asps
asramas938303asramas
ataman81013063ataman
atamans9710433atamans
atap66722453ata_p_
atmans84413963atmans
atmas75721013a_tmas
atoms76817563atom_s
aubades1038743aubades
avails939693avails
awaits96411953awaits
awakes135012473awakes
awards107113453awards
ayahs116813523aya_hs
azans146516883aza_ns
baals76122703_baals
baas66844673_ba_as
baases85218013baases
babas96325733_babas
babes95834113_babes
babus95620333_babus
backs135729623_backs
bads77048863_ba_ds
baffs134718053_baffs
bags76645503_ba_gs
bahts105617803_bahts
bails75933523_bails
baits76630583_baits
bakes117035373_bakes
balas76937213_balas
balds85524643_balds
bales76250083_bales
balks114926293_balks
balls76236413_balls
balms95723923_balms
bals66354043_ba_ls
bam78560143_bam__
bands85233423_bands
banes74945583_banes
bangs85627773_bangs
banks115527903_banks
banns75321233_banns
bans66555133_ba_ns
bap76455843_ba_p_
barbs95928193_barbs
bards87139643_bards
bares75457133_bares
barfs104826003_barfs
barks115735813_barks
barms96128463_barms
barns76335143_barns
bars66564093_ba_rs
bas58681753_ba__s
bases75644353_bases
basis75429863_basis
basks115621763_basks
bass66146783_ba_ss
basts75936933_basts
bates75846343_bates
baths105922923_baths
bats66962333_ba_ts
batts76727563_batts
bauds85821043_bauds
bawds116115493_bawds
bawls105719323_bawls
bayamos1434663bayamos
bays97143913_ba_ys
beams95328173beam_s
beeps95320973_beeps
bemas96424283_bemas
bimas95521743_bimas
blames105121863blames
blams95023853blam_s
blimps12588153blimps
blips95615783_blips
bombs115818823_bombs
bops86037983_b_ops
bumfs125414053_bumfs
bump106228243_bump_
bumph144911983_bumph
bumphs15467103_bumphs
bumpy144715053_bumpy
bums85934593_bum_s
burps94220173_burps
cabalas113516003cabalas
cabals104020153caba_ls
cabanas112413033cabanas
calamus1139243calamus
camas96333523_camas
cames97047313_cames
camos95927613_camos
camp106336453_camp_
campi116217783_campi
campo115219763_campo
campos125217953_campos
campus125213923_campus
campy145116183_campy
cams87047283_cam_s
caps87147893_ca_ps
carps96932253_carps
champ145017963champ_
champy18509613champy
chams126028503cham_s
chaps125326063cha_ps
chimps155713663chimps
chomps155112223chomps
chumps154313823chumps
clamp115517653clamp_
clams95127673clam_s
claps95626183cla_ps
clasps104512093clasps
clomps125212233clomps
clumps1215314643clumps
comps115526053_comps
cramp115120693cramp_
crampy154710993crampy
crams96229153cram_s
craps95328643cra_ps
crimps124613453crimps
crumps124514343crumps
dames85435853_dames
damns84916923_damns
damp96228843_damp_
dams77444373_dam_s
daps77239163_da_ps
decamps1435643decamps
dramas95814653dramas
drams86025833dram_s
dumps105220103_dumps
encamps1335423encamps
exams14199083exam_s
fames105735923_fames
flames114723693flames
flams105125013flam_s
flaps105621383fla_ps
flumps135112503flumps
foams105017953foam_s
frames115119863frames
fraps105620553fra_ps
frumps13479783frumps
gamas85431353_gamas
gambs105721123_gambs
games86238553_games
gamp98833213_gamp_
gams76648883_gam_s
gaps76042973_ga_ps
gasps85415483_gasps
gawps115911013_gawps
gazumps2131873gazumps
gimps105915203_gimps
glams85822933glam_s
gramas94317203gramas
gramp106218323gramp_
grampa115010173grampa
grampas12399253grampas
grampus12356313grampus
grams85327313gram_s
grasps9489253grasps
grumps114510573grumps
hames106138703_hames
hams96446133_ham_s
haps96443463_ha_ps
harps105926863_harps
hasps105114643_hasps
heaps105223223hea_ps
hemps126917333_hemps
humps126322803_humps
iambs95815063_iambs
imams91511113imam_s
imps86221123__imps
jalaps15299183jala_ps
jambs166014623_jambs
jams135231073_jam_s
jaups144810533_jaups
jumps165116493_jumps
kababs14409773kaba_bs
kabakas12367403kabakas
kabalas133911063kabalas
kabars124513953kaba_rs
kabayas16316803kabayas
kalams12310603kalam_s
kames115024693_kames
kbars114612603kba_rs
kemps135012523_kemps
knaps115511173kna_ps
lamas75532793_lamas
lambs95921413_lambs
lames75445543_lames
lamp86233823_lamp_
lampas106615953_lampas
lams66552263_lam_s
laps66848873_la_ps
leaps75522933lea_ps
limps95522673_limps
llamas888973llamas
loams75619863loam_s
lumps95624983_lumps
madames12310063madames
madams11310943madam_s
mamas95930773_mamas
maps86141043_ma_ps
mumps115619103_mumps
names74833363_names
naps66238583_na_ps
neaps75618323nea_ps
obas65730933oba__s
ogams84112683ogam_s
pajamas18278153pajamas
palps94719563_palps
pampa114913423_pampa
pampas124913993_pampas
pams85641763_pam_s
panamas113112753panamas
paps86443453_pa_ps
paramos113213513paramos
pimps114616983_pimps
plumps124612613plumps
pomps115316193_pomps
prams96125513pram_s
preamps1336613preamps
primps124711823primps
pumps115520603_pumps
qabalas18289503qabalas
rabatos93010893rabatos
rabats83116223raba_ts
ramp85934003_ramp_
rams65950773_ram_s
ramus76418283_ramus
raps66247733_ra_ps
rasps74316663_rasps
reams75729623ream_s
reaps75626193rea_ps
remaps105012873remaps
revamps1433993revamps
roams74919613roam_s
romps94617543_romps
rumps95922293_rumps
sabals84618863saba_ls
salamis9313513salamis
salps74423243_salps
samp85733593_samp_
saps65346373_sa_ps
scalps104315233scalps
scamp115717313scamp_
scampi12469103scampi
scams94423973scam_s
scarps104718603scarps
scaups105411933scaups
seams75731663seam_s
shamas113717933shamas
shames114726223shames
shamos114216983shamos
shams105829413sham_s
shamus114112813shamus
sharps115516083sharps
simps94719763_simps
skimps14488043skimps
slams74927903slam_s
slaps76025713sla_ps
slumps104313583slumps
snaps74719563sna_ps
soaps75120713soa_ps
spams94922193spam_s
stamp95217363stamp_
stomps105612833stomps
stumps104912283stumps
sumps95023433_sumps
swamis114212293swamis
swamp125015323swamp_
swampy16437233swampy
swaps104819203swa_ps
tabards10310383tabards
tames75242013_tames
tamis76728723_tamis
tamp86133003_tamp_
tams67247933_tam_s
taps66050673_ta_ps
taramas9612693taramas
tarps76527113_tarps
tatamis939713tatamis
teams75726513team_s
temps95417133_temps
thumps13449353thumps
tramp96319773tramp_
trampy13499253trampy
trams75327673tram_s
traps75727483tra_ps
tromps104911703tromps
trumps104611883trumps
tumps95420793_tumps
ulamas8910453ulamas
umamis1038273umamis
umps85721943__umps
vamp115521543_vamp_
vampy15539403_vampy
wakames1635283wakames
wames106432803_wames
wampus13499013_wampus
wamus105514683_wamus
waps96642083_wa_ps
warps107126423_warps
wasps106714693_wasps
wataps11248683wata_ps
whams135515643wham_s
whaps135115163wha_ps
whaups14405753whaups
whomps16457603whomps
whumps16427093whumps
wimps125213803_wimps
wraps105617153wra_ps
yams95330733_yam_s
yaps95933523_ya_ps
yaups105910743_yaups
yawps13628793_yawps
zaps156826893_za_ps

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.1401276364.3
2DLD Change Limit1127164736.65616934.5
3Display Results4734730.1403378.6
 (SQL Overall)1786914736.93625762.8
 
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.