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

477 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
ambeer10451159(None) 
ambeers11428921ambeers
amber94523201amb_er
ambler104916441ambler
ameer75618981am_eer
abler75624312a_bler
ambers104519562ambers
ambery133811122ambery
amble95924632amble_
ambled115116352ambled
amblers115213562amblers
ambles105121852ambles
ameers84015572am_eers
ammeter1148392ammeter
ampere10514412ampere
ampler104313302ampler
amuser84712622amuser
beer65635992__beer
camber124418472camb_er
ember95516792emb_er
emeer74815362em_eer
gambier124711962gambier
gambler123612682gambler
lamber104418492lamb_er
lambier113611632lambier
omber95316432omb_er
rambler113313262rambler
umber94617582umb_er
abaser86414343abaser
abater85518123abater
abbe87627183a_bbe_
abbes96723523a_bbes
abbess10509773abbess
abbey125714933a_bbey
abbeys13538423abbeys
abeam9316533a_beam
abed79734133a_b_ed
abele76323253a_bele
abeles84719393a_beles
abet610547943a_b_et
abets75621673a_bets
abetter958323a_better
abhor10411063a_bhor
abider95314463abider
able66340533a_ble_
abled86926833a_bled
ables75935543a_bles
abuser85413683abuser
abye97921003a_bye_
abyes105518533a_byes
acceder1235353acceder
achier113914263achier
ackee115825363ackee_
ackees124914573ackees
acuter84412863acuter
adder75419593a_dder
adeem8311803a_deem
adhere10310333adhere
adherer1137563adherer
admirer1035513admirer
adorer74713443adorer
aerier64823153aerier
aether94213673aether
afreet9315153afreet
after85719793a_fter
agee56241493a_gee_
ager55935843a__ger
agger76420893a_gger
aglee65728493aglee_
agree65226033agree_
agreed84712503agreed
agrees74915323agrees
aider65431133a_ider
aimer75926823a_imer
airer54927893a_irer
airier64619363airier
aiver85725163a_iver
ajee115928233a_jee_
akee85936813a_kee_
akees96119243a_kees
albedo956123albedo
albeit8314343albeit
alder65421913a_lder
alee46652323a_lee_
aliener71011193aliener
aliner65621983aliner
allee54932123allee_
allees64521483allees
alleger8319623alleger
almner85710723almner
almoner949383almoner
alter54828503a_lter
alterer72713993alterer
amasser9418733amasser
amateur933883amateur
amaze166016603amaze_
amazed18519303amazed
amazes175613473amazes
ambage11510593ambage
ambages1269623ambages
ambari103012153ambari
ambary134010533ambary
amberies122514673amberies
ambient11310083ambient
ambit94223693amb_it
ambits103713393ambits
ambivert1545613ambivert
ambo88225133amb__o
ambones11312683ambones
ambos95321243amb_os
ambries111614533ambries
ambry123512093amb_ry
ambush1336103ambush
ambusher1544113ambusher
ameba9312373am_eba
amebae1049633amebae
ameban1039093ameban
amebas10311453amebas
amebean1144853amebean
amebic1239103amebic
amen66733153am__en
amend85717753am_end
amender10349613amender
amens75624843am_ens
ament76036543am_ent
amercer1146373amercer
amice96122863amice_
amices105018013amices
amide86128473amide_
amides95722663amides
amie66339843am_ie_
amies76837683am_ies
amine75835373amine_
amines84727983amines
amir65129743am__ir
ammeters1237693ammeters
amoeba1035593amoeba
amole75724593amole_
amoles84122193amoles
amour75014853am_our
amped104820513am_ped
amperes11313983amperes
ample94720303ample_
amreeta945163amreeta
amulet8419573amulet
amuse75920833amuse_
amused94412513amused
amusers94610193amusers
amuses85117943amuses
anear55420323a_near
anger66225873a_nger
angler74017863angler
answer936893answer
antbear935063antbear
anteed75616113anteed
anther93715063anther
antler64615553antler
apeek114711873a_peek
aper66336233a__per
appear10379343appear
apter76120203a_pter
arbiter939933arbiter
arbor74818113arb_or
arbour84211323arbour
archer115016243archer
arguer74510543arguer
arider74717743arider
armer76924443a_rmer
armiger1036253armiger
armorer9259903armorer
arrear6310253arrear
artier63419733artier
ashier94714833ashier
ashler9459973ashler
asker96418783a_sker
asleep847283asleep
asper75520433a_sper
aster55434893a_ster
atoner64817193atoner
atween9166613atween
auger64922473a_uger
aulder7511453aulder
auteur6107943auteur
aver75931883a__ver
avower1236823avower
awee76336643a_wee_
axseed1456993axseed
babbler104012823babbler
babier103515563babier
barber104419323barb_er
baubee103215993baubee_
baubees11348713baubees
bawbee132714233bawbee_
bawbees14337243bawbees
bear66844643__bear
bebeeru1144263bebeeru
bee56262403__bee_
beef96233673__beef
been65335783__been
beep85931213__beep
beers75628393__beers
beery105220123__beery
bees65453383__bees
beet66457543__beet
bibber94613573bibber
bier65531823__bier
bobber95016743bobber
bomber125014653bomb_er
bumbler134013233bumbler
caber95126833cab_er
cabler104519173cabler
cambered15128993cambered
cambers134017433cambers
cameleer1246033cameleer
camper124722213cam_per
campier133313273campier
career85822243career
chamber164011053chamb_er
cheer105420383_cheer
clamber133311733clamb_er
clamberer15185263clamberer
cobber124116843cobber
comber125118503comb_er
compeer133811553compeer
cuber95222533cub_er
cumber124016703cumb_er
cumberer14266993cumberer
cyber124910383cyb_er
dabber114816963dabber
dabbler124012153dabbler
damager1157973damager
dammer114317933dam_mer
damneder1243763damneder
damner95213433dam_ner
dampener1335533dampener
damper114117753dam_per
dauber94112013daub_er
daubier1037093daubier
deer56739023__deer
dibber114614713dibber
dobber114015413dobber
dubber113814553dubber
dumber114414173dumb_er
embar94011593emb_ar
embed105014293emb_ed
embeds11377893embeds
embers104116173embers
emblem1237573emblem
embower14267403embower
emcee9315943emcee_
emceed1136283emceed
emcees1037813emcees
emeers83314183em_eers
emmer94314463em_mer
emoter85415193emoter
fabber134814113fabber
fabler116115813fabler
fakeer13378743fakeer
fibber134811933fibber
fiber104921133fib_er
flambee144210013flambee_
flambeed16324383flambeed
fleer86020773_fleer
freer86021243_freer
fumbler143610813fumbler
gabber114916603gabber
gabbier12379633gabbier
gabbler124013303gabbler
gambe106219213gamb_e_
gambes116318313gamb_es
gambiers13337073gambiers
gambir11509753gamb_ir
gamble115417183gamble_
gambled134112163gambled
gamblers13369733gamblers
gambles124016203gambles
gambrel1235453gambrel
gamer84928943gam__er
gamier93617933gam_ier
gammer1112318333gam_mer
gammier123711193gammier
garbler104012563garbler
gibber114112863gibber
giber85417703gib_er
gombeen1243733gombeen
hammer138120033ham_mer
hammerer15278143hammerer
hammier143510653hammier
hamper134518653ham_per
hamperer15379093hamperer
hamster12810423hamster
hobber134114633hobber
humbler143411943humbler
imager9108113imager
imbed105013633imb_ed
imbeds11456723imbeds
imbiber1333573imbiber
imbower14235653imbower
imbue939463imbue_
imbued1136153imbued
imbues1037963imbues
impeder12438533impeder
jabber173713643jabber
jabberer1944023jabberer
jambe165314753jamb_e_
jambeau1843773jambeau
jambed184811403jamb_ed
jambes175914053jamb_es
jammer174014133jam_mer
jammier18408023jammier
jeer115426463__jeer
jibber174111243jibber
jiber145115703jib_er
jobber173813353jobber
jumbler183910273jumbler
kamseen1344013kamseen
labeler92310183labeler
lambed115614783lamb_ed
lambent113711303lambent
lambers113817103lambers
lambert113617113lambert
lambie103213663lambie_
lambies113015103lambies
lamer75233703lam__er
lamster9109913lamster
laveer94110423laveer
leer46239353__leer
libber104414003libber
libeler9219003libeler
liber74723613lib_er
limber104316773limb_er
limberer12187043limberer
limbier11349093limbier
lobber104016593lobber
lubber104214623lubber
lumber103817773lumb_er
lumberer12177583lumberer
mabe85733343mab_e_
mabes96331533mab_es
macer912126943_macer
madder103515593madder
mailer84724183mailer
maimer104514593maimer
maker114127813_maker
mamboed14417623mamboed
mamboes135011823mamboes
mammee94417853mammee_
mammees104411143mammees
mammer94218863mammer
mamzer19459833mamzer
manger94325003manger
manner84020513manner
mapper124516093mapper
marbler113511673marbler
marker124420393marker
marrer83716673marrer
maser75029973_maser
masher114123203masher
masker124416103masker
master84831343master
mater74438863_mater
matier84321523matier
matter84325343matter
mauger93813483mauger
mauler84416713mauler
mazer165722423_mazer
mazier175013063mazier
meed74934703_m_eed
meek105624833_m_eek
meeker12359983_meeker
meet65350553_m_eet
meeter83616503_meeter
member12258853memb_er
mere67244443_m_ere
merer75126233_merer
meter75130323_meter
miler75733063_miler
mimer94825763_mimer
miner76933543_miner
miser75430403_miser
miter75734793_miter
mixer145017643_mixer
mobber123613463mobber
moper94925923_moper
mover104220863_mover
mower104523453_mower
mumbler133510913mumbler
muser76024123_muser
muter74525543_muter
nabber104913543nabber
namer75622103nam__er
nimbler11358053nimbler
nobler83713453nobler
number103913223numb_er
numberer12186313numberer
obeyer1135893_obeyer
ombers104214393ombers
ombre94111793ombre_
ombres103911133ombres
omer67028393om__er
orbier839983orbier
pamper124316663pam_per
pamperer14228333pamperer
peer66238353__peer
queer143712813_queer
rabbler113514093rabbler
ramble104519973ramble_
rambled123913513rambled
ramblers124010373ramblers
rambles113118313rambles
ramee74633853ram_ee_
ramees84620893ram_ees
rammer103519653ram_mer
rammier112811023rammier
ribber103515493ribber
ribier84414223ribier
robber103916533robber
rubber104715793rubber
rubier84814733rubier
rumbler113514113rumbler
saber75330243sab_er
sambaed1238303sambaed
sambar103914163samb_ar
sambhar1444853sambhar
sambhur1453083sambhur
sambur10469503samb_ur
sampler113212013sampler
seer45547043__seer
sheer84726893_sheer
smear74416393sm_ear
smeek114912353sm_eek
smiler83916683smiler
smiter83616413smiter
smoker124311693smoker
sneer54919953_sneer
sobber104016583sobber
sober74822403sob_er
soberer93110353soberer
somber103713993somb_er
speer74623903_speer
steer55423863_steer
suber74924503sub_er
sweer84918573_sweer
taber73825823tab_er
tambour1136343tambour
tambur10358713tamb_ur
tamer75230103tam__er
tamper104618513tam_per
tamperer12248893tamperer
timber104012673timb_er
tubber104313203tubber
tuber75420683tub_er
tumbler113412823tumbler
umbel93612833umb_el
umbeled12208193umbeled
umbels104510583umbels
umbered121510113umbered
umbers104215203umbers
umbles103817483umbles
unbear889163unbear
upbear1096493upbear
vamper134212653vam_per
vampier14308233vampier
veer76229573__veer
veneer94511693veneer
wabbler143511923wabbler
wamble134415753wamble_
wambled153610753wambled
wambles143714023wambles
wamblier15275733wamblier
warbler123211463warbler
weber10313523web_er
weer75535093__weer
wombier1436533wombier
yabber136111833yabber
yammer133713183yam_mer
yammerer15225483yammerer

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.1431249587.4
2DLD Change Limit1127164776.64016975.3
3Display Results4774770.1702805.9
 (SQL Overall)1786914776.95325699.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.