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

244 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
amebic123911(None) 
amoebic1346151amoebic
acerbic1335642acerbic
acetic10314502acetic
alembic1354772alembic
ambit94223712am_bit
ameba9312382ameb_a
amebae1049632amebae
ameban1039092ameban
amebas10311452amebas
ameboid1277222ameboid
amidic114012862amidic
aminic104413512aminic
amnesic1137182amnesic
amnic95516242am_nic
amylic13108702amylic
anemic102713692anemic
arabic10312732arabic
areic73219392are_ic
atelic8313702atelic
axenic154210002axenic
emetic10614452emetic
gametic1239982gametic
iambic12468272iam_bic
medic104619652_medic
melic94722332_melic
mesic93617862_mesic
abelia83114403abelia
abulic106411423abulic
acedia9310393acedia
acetin8314693acetin
acidic113612133acidic
acinic104713543acinic
acmatic13311693acmatic
acmic11312333a_cmic
adipic1137263adipic
aecia73819283a_ecia
aegis6316783a_egis
aeonic83517043aeonic
aerie54634603a_erie
aerobic11310213aerobic
agamic113110543agamic
agaric93513623agaric
agonic93515143agonic
albeit8314343albeit
alcaic1039983alcaic
alec66430063ale__c
alembics1442963alembics
alevin92511513alevin
alexia132910463alexia
alexin132311483alexin
alibi7514233alibi_
alibis8311073alibis
allelic9118173allelic
aloetic9313183aloetic
amain74922893am_ain
ambeer104511603ambeer
amber94523213am_ber
ambers104519573ambers
ambery133811133ambery
ambits103713413am_bits
amble95924643am_ble
ambo88225143am_b_o
ambos95321253am_bos
ambry123512103am_bry
amebean1144853amebean
ameer75618983ame_er
ameers84015573ameers
amen66733153ame__n
amend85717753ame_nd
amends94713283amends
amenity1238333amenity
amens75624843ame_ns
ament76036543ame_nt
amentia9310153amentia
aments85219803aments
amerce10310513amerce
amesace1147733amesace
ami56646813am__i_
amia66836903am__ia
amice96122873am__ice
amici94217393am__ici
amid77036343am__id
amidin94015663amidin
amie66339853am__ie
amin66042253am__in
amir65129753am__ir
amis66445323am__is
ammonic1349163ammonic
amnesia938293amnesia
amnesiac1265073amnesiac
amnesics1255283amnesics
amnestic1247053amnestic
amnia75918643am_nia
amnio75218053am_nio
amoeba1035603amoeb_a
amoebae1145533amoebae
amoeban1144913amoeban
amoebas1135963amoebas
amoeboid1344103amoeboid
amtrac10109123amtrac
amusia839173amusia
anaemic1149903anaemic
anemia82613573anemia
anergic1048103anergic
angelic1039613angelic
anisic8313793anisic
anodic92813133anodic
anomic102516303anomic
anoxic152610673anoxic
antic75728863a_ntic
anuric8812093anuric
aortic8316613aortic
aphetic142912853aphetic
apneic1078623apneic
arabica1147283arabica
arctic10313513arctic
arsenic939323arsenic
ascetic11310063ascetic
asdic83814093a_sdic
aseptic1137373aseptic
aspic95114733a_spic
atavic11189293atavic
ataxic15169203ataxic
atomic104115603atomic
atonic83420473atonic
atopic103514143atopic
atresic9310003atresic
atretic9313923atretic
attic75618353a_ttic
atypic13337653atypic
aulic74420243a_ulic
auric74521723a_uric
auxetic1637143auxetic
axonic154312723axonic
azoic162912063a_zoic
azonic175513153azonic
azotic172711623azotic
cambia124913153cam_bia
cambric1537363cambric
camelia11510433camelia
camelid1249393camelid
caseic103212373case_ic
cebid104314073_cebid
ceric94023093_ceric
chebec1536963chebec
chemic153012093chemic
cleric10612133cleric
comedic14158633comedic
cometic131215713cometic
cretic102816283cretic
cubic114313423_cubic
debit85727853_debit
demic105119193_demic
dimeric12310013dimeric
ecesic10369223ecesic
edenic9310223edenic
emesis84712623emesis
emetics11610723emetics
emetin8613463emetin
emic86422753__emic
endamebic1652883endamebic
ephebic1646513ephebic
epic86921303__epic
etic66123953__etic
galenic1038693galenic
gambia115912243gam_bia
gambir11509763gam_bir
gambit114714203gam_bit
gamic103916193gam__ic
genic85119393_genic
haemic133210083haemic
hemic125718623_hemic
homeric14312213homeric
hyenic1438723hyenic
iambi95512213iam_bi_
iambics13425643iam_bics
imidic11358203imidic
irenic8311103irenic
lambie103213673lam_bie
limbic12528743limbic
luetic8310383luetic
mafic125615463_mafic
magic105818653_magic
malefic1486323malefic
malic94525653_malic
manic94629433_manic
mantic104120903mantic
mastic103119173mastic
media84721713_media
medick154010133_medick
medico113711163_medico
medics114115353_medics
medii84513493_medii
merc87225623_me_rc
merit7339183_merit
metis75025903_metis
metric10314673_metric
mic77647643_m__ic
mimetic1338643mimetic
mimic111414323_mimic
music94316403_music
niobic1037243niobic
noetic8514043noetic
numeric1158193numeric
oleic7313333ole_ic
paretic113016673paretic
phobic153010063phobic
poetic10416843poetic
prebid113512843prebid
pubic114513723_pubic
pyemic1537893pyemic
rabic93817403_rabic
racemic1336983racemic
ramekin13126493ramekin
rarebit948423rarebit
rebec94416543_rebec
rebid85121363_rebid
relic74623363_relic
scenic10510513scenic
sememic1336503sememic
sepic94617053_sepic
smectic1336603smectic
sorbic10310383sorbic
stelic8313083stelic
steric8317063steric
tabetic1138463tabetic
tagmemic1542703tagmemic
tambac122210243tam_bac
tamein8313083tame_in
taxemic1835243taxemic
telic76019823_telic
terbic10410963terbic
terebic1137983terebic
thetic11412883thetic
tmesis8529793tmesis
ureic74514463ure_ic
uremic103410513uremic
uretic82914353uretic
valeric1238303valeric
xebec16378293_xebec
xenic144114643_xenic
xeric144315663_xeric
zebec18419263_zebec

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 Limit1127162446.17318259.5
3Display Results2442440.0763210.5
 (SQL Overall)1786912446.38927968.5
 
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.