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

270 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
agamid10371067(None) 
agamic113110541agamic
agamids11317001agamids
aramid93315601aramid
acarid95017062acarid
again65218112aga_in
agama85815572agam_a
agamas97413442agamas
agaric93513622agaric
agatoid948602agatoid
amid77036332__amid
aramids102810502aramids
gadid85517372_gadid
gamed95126392_gamed
gamic103916192_gamic
gamin84422992_gamin
aahed917816443a_ahed
aalii5316123a_alii
abaci94718843abaci_
abamp11310603abam_p
abamps1236253abamps
abased96514993abased
abasia8712953abasia
abated95918453abated
abatis84317933abatis
acacia10311353acacia
acari75020283acari_
acarids105312243acarids
acaroid103512303acaroid
acetamid1344783acetamid
acid77533393__acid
acmic11312333a_cmic
acrid86920103a_crid
adagio847663adagio
admit8319493a_dmit
admix1557723a_dmix
afraid1049713afraid
aga410447233aga___
agamete1037393agamete
agamous1037923agamous
agapae9388043agapae
agapai9456843agapai
agape85614843aga_pe
agapeic1244703agapeic
agapes95212413agapes
agar58726413aga__r
agarics10319943agarics
agars66120643aga_rs
agas55938843aga__s
agate66525143aga_te
agates76121333agates
agatize1739833agatize
agatized1947073agatized
agave95314033aga_ve
agaves104611513agaves
agaze156113663aga_ze
aged67334253ag__ed
aggadic1254783aggadic
aggie73415013ag_gie
agin56132713ag__in
agio57828453ag__io
agma77623263ag_m_a
agmas85919873ag_mas
agnail739523agnail
agnatic10310963agnatic
agonic93515143agonic
agravic1345883agravic
agreed84712503agreed
agria65517143ag_ria
aid49269073__a_id
aimed85626053a_imed
alameda1035493alameda
alamo7418143alam_o
alamode1038153alamode
alamos8415003alamos
aland65526413ala_nd
alanin6317273alanin
alarmed1037733alarmed
alated75625143alated
alcid85817963a_lcid
algid75415573a_lgid
algoid83011463algoid
almud84012183a_lmud
alumin8513543alumin
amain74922883ama_in
amazed18519303amazed
ami56646803__ami_
amia66836893__amia
amide86128473__amide
amido85720963__amido
amids85627503__amids
amie66339843__amie
amin66042243__amin
amir65129743__amir
amis66445313__amis
anaemia959803anaemia
anaemic1149903anaemic
anemia82613573anemia
anemic102713693anemic
angaria8311553angaria
animi74016663animi_
animis84615943animis
anomic102516303anomic
anomie83215963anomie
antacid10311203antacid
aphid115515393a_phid
apogamic1544993apogamic
arabic10312733arabic
arame75026623aram_e
arames84622573arames
araneid8310793araneid
argali75013743argali_
argalis84214183argalis
arid57642713__arid
armed86324433a_rmed
aroid65428333a_roid
ascarid103910713ascarid
ashamed1336243ashamed
ataman81013063ataman
atavic11189293atavic
ataxia13179593ataxia
ataxic15169203ataxic
atomic104115603atomic
avail8313883ava_il
avid88325963__avid
avoid95516673a_void
await85524493awa_it
awaked14579203awaked
award97118043awa_rd
barmaid1238193barmaid
beamed115720733beamed
blamed116017953blamed
braid85822263bra_id
bromid112612893bromid
caid77837533_ca_id
calami10313423calami_
canid85526343_canid
carabid12311333carabid
cosmid11810643cosmid
cyanamid1644203cyanamid
cyanid123912033cyanid
degami10279003degami_
degamis11268433degamis
desmid1048363desmid
diacid10310633diacid
diamide1138473diamide
diamin9312513diamin
egad64215413ega__d
elapid939543elapid
etamin81311853etamin
famed115928343_famed
flamed124618973flamed
foamed126014403foamed
framed125116523framed
gad57556653_ga__d
gaddi85211633_gaddi
gadi66329723_gadi_
gadids95611823_gadids
gadis74825293_gadis
gadoid9310443gadoid
gaed66031513_ga_ed
gaged85522313_gaged
gain56042163_ga_in
gait56150193_ga_it
gam67060063_gam__
gama77035513_gam_a
gamas85431353_gamas
gamay116419103_gamay
gamb96331843_gam_b
gamba106018513_gamba
gambe106219213_gambe
gambia115912233_gambia
gambir11509753_gambir
gambit114714193_gambit
gambs105721123_gambs
game76644323_gam_e
gamer84928943_gamer
games86238553_games
gamey115320553_gamey
gamier93617933_gamier
gamily123712183_gamily
gamine94620153_gamine
gaming104622043_gaming
gamins94420043_gamins
gamma106116103_gamma
gammed124216163gammed
gammy135514893_gammy
gamp98833213_gam_p
gamps105323713_gamps
gams76648883_gam_s
gamut8322983_gamut
gamy105427533_gam_y
ganoid8314433ganoid
gaped96123533_gaped
gated75329773_gated
gaud67025433_ga_ud
gaumed104610323gaumed
gazed165520333_gazed
gelid74916973_gelid
geoid74215753_geoid
gid57047263_g__id
gravid113710973gravid
grid65829613_g_rid
guid66022823_g_uid
hagadic1445853hagadic
halid94424973_halid
humid114213763_humid
iguanid944543iguanid
imid76122273__imid
kami105823643_kami_
kamik105011553_kamik
laid56439143_la_id
lamed85235293_lamed
lamia75324323_lamia
loamed94414613loamed
maid75537633_ma_id
mamie95826003_mamie
mid67354453___mid
named85223063_named
navaid1037643nava_id
ogam75120033ogam__
ogams84112683ogam_s
oghamic1544043oghamic
ozalid1696673ozalid
pagurid11105433pagurid
paid75737483_pa_id
pavid115717003_pavid
phasmid15267603phasmid
placid114012543placid
plaid85118303pla_id
plasmid12239553plasmid
pyramid1547503pyramid
qaid146023843_qa_id
rabid84520773_rabid
raid55243073_ra_id
rami66034093_rami_
ramie75027823_ramie
ranid66429333_ranid
rapid86422033_rapid
reamed94326123reamed
roamed95215093roamed
sagaman10117553sagaman
sagamen10127503sagamen
said55742113_sa_id
salami8313103salami_
salamis9313513salamis
sapid84720933_sapid
sayid95516723_sayid
seamed94823883seamed
shamed125120213shamed
sialid7314933sialid
siganid947183siganid
sparid94016933sparid
staid66722073sta_id
swami105614523swami_
swamis114212293swamis
tabanid1047323tabanid
tabid84418253_tabid
tamed85528513_tamed
tamis76728723_tamis
tatami839183tatami_
tatamis939713tatamis
teamed95418593teamed
timid84815713_timid
tumid84114023_tumid
umami939883umami_
umamis1038273umamis
valid94618383_valid
vapid115614283_vapid
zamia165115213_zamia

Search took 6 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 Limit1127162705.51620434.4
3Display Results2702700.0803375.0
 (SQL Overall)1786912705.73631152.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.