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

184 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
agamids1131701(None) 
agamid103710691agamid_
aramids102810511aramids
acarids105312242acarids
agamas97413452agam_as
agamic113110562agami_c
agamous1037942agamous
agarics10319942agarics
amids85627512__amids
aramid93315612aramid_
gadids95611822_gadids
gamins94420042_gamins
aaliis6312903a_aliis
abamps1236253abam_ps
abasias9711013abasias
abatis84317933abati_s
acacias11510403acacias
acarid95017073acarid_
acetamids1443443acetamids
acids87121003__acids
adagios945513adagios
admits9411413a_dmits
again65218123aga_i_n
against838383aga_inst
agama85815583agam__a
agamete1037403agamete
agametes1147293agametes
agapes95212413aga_pes
agaric93513633agari_c
agars66120643aga__rs
agas55938843aga___s
agates76121343aga_tes
agatize1739833agatize
agatizes1838863agatizes
agatoid948623agatoid_
agaves104611513aga_ves
aggies83515513ag_gies
agios65919863ag__ios
agmas85919873ag_m_as
agnails837003agnails
agonies83016623agonies
agrias74315393ag_rias
aids57846363__a_ids
alameda1035493alameda
alamedas1145443alamedas
alamode1038153alamode
alamodes1148013alamodes
alamos8415003alam_os
alands75418373ala_nds
alanins7315803alanins
alcids94812293a_lcids
almuds9378773a_lmuds
alumins9512983alumins
amias75831473__amias
amid77036353__amid_
amide86128483__amide
amides95722663__amides
amido85720983__amido
amidst94913233__amidst
amies76837693__amies
amins75534323__amins
amirs75924923__amirs
amis66445323__ami_s
amiss75823073__amiss
anaemias1069203anaemias
anemias92512143anemias
angarias9310553angarias
angaries9314393angaries
animis84615943animi_s
anomies93316993anomies
antacids1148333antacids
aphids125110843a_phids
apogamies1445323apogamies
arames84622573aram_es
araneids947743araneids
argalis84214193argali_s
armies85123693a_rmies
aroids75118223a_roids
ascarids11438503ascarids
atamans9710433atamans
ataxias14189343ataxias
ataxics16196643ataxics
ataxies142410013ataxies
atomics113110853atomics
atomies93918363atomies
avails939693ava_ils
avoids104410203a_voids
awaits96411953awa_its
awards107113453awa_rds
barmaids1345943barmaids
bigamies1337373bigamies
braids95015693bra_ids
bromids12278603bromids
caids85226423_ca_ids
canids95118133_canids
carabids1338193carabids
cosmids1237633cosmids
cyanamids1743163cyanamids
cyanids13297933cyanids
degamis11268443degami_s
desmids1166603desmids
diacids1137863diacids
diamide1138473diamide
diamides1238823diamides
diamins10312213diamins
digamies1238643digamies
egads74610923ega__ds
elapids1036503elapids
etamins91511833etamins
gabies93820733_gabies
gaddis94211373_gaddis
gadid85517383_gadid_
gadis74825293_gadi_s
gadoids1036873gadoids
gads67843383_ga__ds
gains65729513_ga_ins
gaits65726013_ga_its
gamas85431363_gam_as
gamays126310913_gamays
gambas115817513_gambas
gambes116318313_gambes
gambias125010733_gambias
gambirs12359083_gambirs
gambits12399723_gambits
gambs105721123_gam_bs
gamed95126393_gamed_
gamers94420833_gamers
games86238553_gam_es
gamic103916203_gami_c
gamier93617933_gamier
gamiest102816223_gamiest
gamily123712183_gamily
gamin84423003_gami_n
gamine94620153_gamine
gamines103618463_gamines
gaming104622043_gaming
gamings114610913_gamings
gammas115714693_gammas
gamps105323713_gam_ps
gams76648883_gam__s
gamuts958783_gamuts
ganoids939333ganoids
gauds75717723_ga_uds
geoids8369843_geoids
gids65933743_g__ids
grids75321393_g_rids
guids75516153_g_uids
halids104016133_halids
iguanids1042913iguanids
imids86015143__imids
kamiks11387913_kamiks
lameds94812033_lameds
lamias85020613_lamias
maids86327143_ma_ids
mamies104626243_mamies
mids76541793___mids
navaids1134803nava_ids
ogams84112683ogam__s
oogamies1147413oogamies
ozalids1794063ozalids
pagurids12144003pagurids
phasmids16195183phasmids
plaids94312443pla_ids
plasmids13236553plasmids
pyramids1645643pyramids
qaids156116313_qa_ids
raids65827513_ra_ids
ramies84630463_ramies
ranids75118703_ranids
rapids94913893_rapids
saids65328853_sa_ids
salamis9313513salami_s
sayids104310973_sayids
sialids839723sialids
siganids1045303siganids
sparids103512123sparids
swamies123712063swamies
swamis114212293swami_s
tabanids1144963tabanids
tamis76728733_tami_s
tatamis939723tatami_s
umamis1038273umami_s
vagaries12310293vagaries
zamias174212923_zamias

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271845.83022989.2
3Display Results1841840.0632920.6
 (SQL Overall)1786911846.28328440.4
 
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.