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
agamid10371069(None) 
agamic113110561agamic
agamids11317011agamids
aramid93315611aramid
acarid95017072acarid
again65218122aga_in
agama85815582agam_a
agamas97413452agamas
agaric93513632agaric
agatoid948622agatoid
amid77036352__amid
aramids102810512aramids
gadid85517382_gadid
gamed95126392_gamed
gamic103916202_gamic
gamin84423002_gamin
aahed917816443a_ahed
aalii5316133a_alii
abaci94718843abaci_
abamp11310603abam_p
abamps1236253abamps
abased96514993abased
abasia8712953abasia
abated95918453abated
abatis84317933abatis
acacia10311353acacia
acari75020283acari_
acarids105312243acarids
acaroid103512313acaroid
acetamid1344793acetamid
acid77533393__acid
acmic11312333a_cmic
acrid86920103a_crid
adagio847673adagio
admit8319493a_dmit
admix1557733a_dmix
afraid1049723afraid
aga410447233aga___
agamete1037403agamete
agamous1037943agamous
agapae9388043agapae
agapai9456863agapai
agape85614843aga_pe
agapeic1244713agapeic
agapes95212413agapes
agar58726413aga__r
agarics10319943agarics
agars66120643aga_rs
agas55938843aga__s
agate66525153aga_te
agates76121343agates
agatize1739833agatize
agatized1947073agatized
agave95314033aga_ve
agaves104611513agaves
agaze156113663aga_ze
aged67334253ag__ed
aggadic1254813aggadic
aggie73415013ag_gie
agin56132713ag__in
agio57828453ag__io
agma77623263ag_m_a
agmas85919873ag_mas
agnail739533agnail
agnatic10310973agnatic
agonic93515143agonic
agravic1345893agravic
agreed84712503agreed
agria65517143ag_ria
aid49269083__a_id
aimed85626053a_imed
alameda1035493alameda
alamo7418143alam_o
alamode1038153alamode
alamos8415003alamos
aland65526413ala_nd
alanin6317273alanin
alarmed1037733alarmed
alated75625143alated
alcid85817973a_lcid
algid75415583a_lgid
algoid83011473algoid
almud84012183a_lmud
alumin8513543alumin
amain74922913ama_in
amazed18519313amazed
ami56646813__ami_
amia66836903__amia
amide86128483__amide
amido85720983__amido
amids85627513__amids
amie66339853__amie
amin66042253__amin
amir65129753__amir
amis66445323__amis
anaemia959803anaemia
anaemic1149903anaemic
anemia82613573anemia
anemic102713693anemic
angaria8311583angaria
animi74016663animi_
animis84615943animis
anomic102516303anomic
anomie83215963anomie
antacid10311223antacid
aphid115515393a_phid
apogamic1545013apogamic
arabic10312733arabic
arame75026623aram_e
arames84622573arames
araneid8310803araneid
argali75013753argali_
argalis84214193argalis
arid57642713__arid
armed86324433a_rmed
aroid65428343a_roid
ascarid103910723ascarid
ashamed1336243ashamed
ataman81013063ataman
atavic11189293atavic
ataxia13179593ataxia
ataxic15169203ataxic
atomic104115603atomic
avail8313883ava_il
avid88325963__avid
avoid95516683a_void
await85524493awa_it
awaked14579203awaked
award97118043awa_rd
barmaid1238203barmaid
beamed115720733beamed
blamed116017953blamed
braid85822263bra_id
bromid112612893bromid
caid77837533_ca_id
calami10313423calami_
canid85526343_canid
carabid12311333carabid
cosmid11810643cosmid
cyanamid1644223cyanamid
cyanid123912043cyanid
degami10279013degami_
degamis11268443degamis
desmid1048363desmid
diacid10310633diacid
diamide1138473diamide
diamin9312523diamin
egad64215413ega__d
elapid939543elapid
etamin81311853etamin
famed115928343_famed
flamed124618973flamed
foamed126014403foamed
framed125116523framed
gad57556653_ga__d
gaddi85211633_gaddi
gadi66329723_gadi_
gadids95611823_gadids
gadis74825293_gadis
gadoid9310463gadoid
gaed66031513_ga_ed
gaged85522313_gaged
gain56042163_ga_in
gait56150193_ga_it
gam67060063_gam__
gama77035523_gam_a
gamas85431363_gamas
gamay116419113_gamay
gamb96331843_gam_b
gamba106018513_gamba
gambe106219213_gambe
gambia115912253_gambia
gambir11509773_gambir
gambit114714213_gambit
gambs105721123_gambs
game76644323_gam_e
gamer84928943_gamer
games86238553_games
gamey115320553_gamey
gamier93617933_gamier
gamily123712183_gamily
gamine94620153_gamine
gaming104622043_gaming
gamins94420053_gamins
gamma106116103_gamma
gammed124216163gammed
gammy135514893_gammy
gamp98833213_gam_p
gamps105323713_gamps
gams76648883_gam_s
gamut8322983_gamut
gamy105427533_gam_y
ganoid8314443ganoid
gaped96123533_gaped
gated75329773_gated
gaud67025433_ga_ud
gaumed104610323gaumed
gazed165520333_gazed
gelid74916983_gelid
geoid74215763_geoid
gid57047273_g__id
gravid113710983gravid
grid65829613_g_rid
guid66022823_g_uid
hagadic1445863hagadic
halid94424983_halid
humid114213763_humid
iguanid944563iguanid
imid76122293__imid
kami105823643_kami_
kamik105011553_kamik
laid56439143_la_id
lamed85235293_lamed
lamia75324323_lamia
loamed94414613loamed
maid75537663_ma_id
mamie95826003_mamie
mid67354473___mid
named85223063_named
navaid1037653nava_id
ogam75120033ogam__
ogams84112683ogam_s
oghamic1544043oghamic
ozalid1696683ozalid
pagurid11105443pagurid
paid75737483_pa_id
pavid115717003_pavid
phasmid15267603phasmid
placid114012543placid
plaid85118303pla_id
plasmid12239553plasmid
pyramid1547513pyramid
qaid146023843_qa_id
rabid84520783_rabid
raid55243073_ra_id
rami66034093_rami_
ramie75027823_ramie
ranid66429333_ranid
rapid86422033_rapid
reamed94326123reamed
roamed95215093roamed
sagaman10117563sagaman
sagamen10127503sagamen
said55742113_sa_id
salami8313103salami_
salamis9313513salamis
sapid84720933_sapid
sayid95516723_sayid
seamed94823883seamed
shamed125120213shamed
sialid7314943sialid
siganid947203siganid
sparid94016933sparid
staid66722083sta_id
swami105614523swami_
swamis114212293swamis
tabanid1047333tabanid
tabid84418263_tabid
tamed85528513_tamed
tamis76728733_tamis
tatami839193tatami_
tatamis939723tatamis
teamed95418593teamed
timid84815733_timid
tumid84114023_tumid
umami939883umami_
umamis1038273umamis
valid94618393_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.373479064.3
2DLD Change Limit1127162705.20321663.7
3Display Results2702700.0932903.2
 (SQL Overall)1786912705.66931520.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.