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

272 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
amebae104963(None) 
ameba9312371ameba_
ameban1039091ameban
amebas10311451amebas
amoebae1145531amoebae
ambage11510592am_bage
amble95924632am_ble
amebean1144852amebean
amebic1239102amebic
amerce10310512amerce
amesace1147732amesace
amoeba1035592amoeba_
amoeban1144912amoeban
amoebas1135962amoebas
areae55229742are_ae
camerae11312042camerae
glebae9407612glebae
aba512850953a__ba_
abas68642083a__bas
abase76023483a__base
abate76627843a__bate
abba810522643a_bba_
abbas95918643a_bbas
abbe87627183a__bbe
abeam9316533abe_am
abele76323253abe_le
able66340533a__ble
abye97921003a__bye
acerate92818913acerate
acerbate1247533acerbate
aceta74017353aceta_
acetal84314903acetal
acetate92514753acetate
adobe84814703adob_e
aerate64830553a_erate
aerie54634603a_erie
agapae9388043agapae
agee56241493age__e
agemate101210583agemate
agene65621583age_ne
agorae7511203agorae
ahead96817053ahe_ad
airbag956963airbag
ajee115928233aje__e
akee85936813ake__e
akela9311343akela_
akelas10311193akelas
akene95818663ake_ne
alae45643753a__lae
alba68328333a_lba_
albas75925393a_lbas
alee46652323ale__e
alegar739283alegar
algae65319623a_lgae
alible8311973alible
almemar1144303almemar
alulae6312743alulae
ama510853303am__a_
amah98927483am__ah
amas67746293am__as
amaze166016603am_aze
ambages1269623am_bages
ambari103012153am_bari
ambary134010533am_bary
ambeer104511593ambeer
amber94523203am_ber
ambers104519563ambers
ambery133811123ambery
ambit94223693am_bit
ambled115116353am_bled
ambler104916443am_bler
ambles105121853am_bles
ambo88225133am_b_o
ambos95321243am_bos
ambry123512093am_bry
ambsace1355963ambsace
amebiases1343723amebiases
ameboid1277223ameboid
ameer75618983ame_er
ameerate1039633ameerate
ameers84015573ameers
amen66733153ame__n
amenable1238863amenable
amend85717753ame_nd
amended11328303amended
amender10349613amender
amends94713283amends
amens75624843ame_ns
ament76036543ame_nt
aments85219803aments
amerced1256523amerced
amercer1146373amercer
amerces1149853amerces
amesaces1246693amesaces
amia66836893am_ia_
amiable11312033amiable
amias75831463am_ias
amice96122863am_ice
amidase1036723amidase
amide86128473am_ide
amie66339843am__ie
amiga85514793amiga_
amigas95912163amigas
amine75835373am_ine
amirate91115953amirate
ammine10314483ammine
amnia75918633amnia_
amoebaean1351283amoebaean
amoebean1242343amoebean
amoebic1346153amoebic
amole75724593am_ole
amoral8314623amoral
amperage1347743amperage
ampere10514413ampere
ample94720303am_ple
ampule10710613ampule
amtrac10109123amtrac
amuse75920833am_use
amylase1237013amylase
anabas8314083anabas
anear55420323ane_ar
anele55628833ane_le
ansae55720973a_nsae
antae56828293a_ntae
aortae65115473aortae
apeak115513453ape_ak
aquae142212713a_quae
arable81821003arable
area45843393are_a_
areal55928733are_al
areas55935773are_as
areca75618633areca_
arecas84817443arecas
arena55323813arena_
arenas65021993arenas
arene55329413are_ne
areolae7811733areolae
areole61017283areole
arepa75615563arepa_
arepas85515703arepas
arete56031353are_te
asea46327183ase_a_
atabal839743atabal
aubade939223a_ubade
aurae54128113a_urae
avenge1087553avenge
avenue957953avenue
average1158853average
averse95811183averse
awee76336643awe__e
axeman1538103axeman
beebee10313063beebee
camera10313673camera_
cameral11311263cameral
cameras11313343cameras
catenae9311363catenae
chelae113614603chelae
debag94212303_debag
debar85517863_debar
debase94014473_debase
debate94419193_debate
debye1138903_debye
embar94011593em_bar
embay123410593em_bay
emerge91510463emerge
emeute838533emeute
endamebae1462593endamebae
entamebae1363173entamebae
eyebar1135323eyebar
feeble1138253feeble
galeae74717453gale_ae
gamba106018513gam_ba_
gambade1336383gam_bade
gambas115817513gam_bas
gambe106219213gam_b_e
gamble115417183gam_ble
gamelan10106643gamelan
gametal1037603gametal
gamete9313593game_te
gemmae11507793gemmae
gleba83910243gleba_
glebe85016443gleb_e
grebe85114943greb_e
hebe96424703_heb_e
imbue939463im_bue
jambe165314753jam_b_e
jambeau1843773jambeau
kebab134311993_kebab
kebar115113533_kebar
lambie103213663lam_bie
lamellae10117023lamellae
lamiae84817453lam_iae
laminae93512973laminae
mabe85733343_mab_e
mae57659103_m__ae
maenad939413maenad
makebate1645063makebate
mamba116317513mamba_
mambas125716243mambas
mammae94613213mammae
marble104219103marble
maybe12311123mayb_e
mead75531603_me_ad
meal65643173_me_al
mean65538083_me_an
meat66359603_me_at
medal86221323_medal
mediae94217413_mediae
mega77620873_mega_
melee73729103_melee
meme85330553_me_me
menace103216943_menace
menad85918983_menad
menage93216543_menage
mensae84114043_mensae
mense75025633_mense
merde84320123_merde
mere67244443_me_re
merge84523683_merge
merle75824373_merle
mesa67025483_mesa_
mesas76823203_mesas
mesne75116293_mesne
meta65932413_meta_
metage93114453_metage
metal75427383_metal
metate82720533_metate
mete64438133_me_te
metre74821303_metre
meze154420903_me_ze
minae75627723_minae
morae75831193_morae
myxamebae2551263myxamebae
namable11312333namable
nameable1238863nameable
namesake1443243namesake
nametag1044443nametag
ombre94111793om_bre
omega836383omega_
omegas936973omegas
paleae84820293pale_ae
plebe95014873pleb_e
prebade12310283prebade
prebake1539093prebake
ramble104519973ram_ble
ramee74633853rame__e
rebar75420193_rebar
rebate84424103_rebate
rebbe9313153_rebbe
samba95618773sam_ba_
sambaed1238303sam_baed
sambal105215183sam_bal
sambar103914163sam_bar
sambas104219263sam_bas
setae56026223_setae
smear74416393sme_ar
stelae63716483stelae
tamable11312843tamable
tambac122210243tam_bac
tambak14249263tam_bak
tameable1238603tameable
telae54323293_telae
thebe107515433theb_e
thecae11299653thecae
treble8311663treble
tubae74716643_tubae
umbrae1038673umbrae
venae85920983_venae
wamble134415753wam_ble
zareba1736423zareba_
zarebas1836303zarebas
zoeae144412483zoe_ae

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 Limit1127162725.79619447.2
3Display Results2722720.0803400.0
 (SQL Overall)1786912726.01629702.6
 
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.