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

171 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
agamous103794(None) 
acajous1666482acajous
agamas97413452agam_as
agamids11317012agamids
alamos8415002alamo_s
amadous1038502amadous
apogamous1444092apogamous
awmous1157712a_wmous
bigamous1385502bigamous
digamous1296062digamous
famous11412392_famous
oogamous1144792oogamous
ramous8417112_ramous
abacus10349763aba_cus
abamps1236253abam_ps
abators94413093abators
acajou1595233acajou_
acarpous1245313acarpous
acarus8312193aca_rus
acaulous1045923acaulous
acerous9513333acerous
acetous9410363acetous
acinous9310933acinous
adipous1037183adipous
aeneous739893aeneous
agama85815583agam__a
agamete1037403agamete
agametes1147293agametes
agamic113110563agam_ic
agamid103710693agam_id
agapes95212413aga_pes
agarics10319943agarics
agarose838673agarose
agaroses938823agaroses
agars66120643aga__rs
agas55938843aga___s
agates76121343aga_tes
agatoid948623agatoid
agaves104611513aga_ves
aggros836553aggro_s
agios65919863ag_io_s
agmas85919873ag_m_as
agons66423783ag__ons
alamo7418143alamo__
alamode1038163alamode
alamodes1148023alamodes
allogamous1353203allogamous
alumnus935223alumnus
amadou977613amadou_
amatols938183amatols
amazons1836653amazons
ammos94815823a_mmo_s
amoks11413553__amoks
amorous9311133amorous
amour75014853__amour
amours83512663__amours
amus65529613__am_us
analogs82810453analogs
angakoks1241883angakoks
anginous947643anginous
angulous946223angulous
animus84211613anim_us
anurous7311553anurous
anxious1437283anxious
apodous1037403apodous
aqueous1636053aqueous
araceous1049183araceous
arames84622573aram_es
aramids102810513aramids
arduous837613arduous
arenous7314183arenous
armors85017813a_rmors
armour84411853a_rmour
armours9389853a_rmours
astomous1047213astomous
atamans9710433atamans
aurous64119263a_urous
autogamous1354193autogamous
azygous2043123azygous
bayamos1434663bayamo_s
bayous11411153_bayous
biramous1266073biramous
brumous11107443brumous
calamus1139243calam_us
camos95927613_camo_s
campus125213923_campus
chamois143512193chamois
chymous1775703chymous
clamors11710093clamors
clamour1196333clamour
clamours1255993clamours
comous10816513_comous
cormous11312353cormous
cymous1388403_cymous
enamors939123enamors
enamour945433enamour
enamours1044663enamours
exogamous1953053exogamous
gagakus1342883gaga_kus
gallous82813953gallous
gallus74313203_gallus
galops94712623_galops
gamas85431363_gam_as
gamays126310913_gamays
gambas115817513_gambas
gambes116318313_gambes
gambols1238593_gambols
gambs105721123_gam_bs
gamers94420833_gamers
games86238553_gam_es
gamins94420053_gamins
gammas115714693_gammas
gammons1237973gammons
gamps105323713_gam_ps
gams76648883_gam__s
gamut8322983_gam_ut
gamuts958783_gamuts
ganofs104010293_ganofs
gaols66717573_ga_ols
gaseous839503gaseous
gators74115843_gators
gavots1038113_gavots
gazoos163010223_gazoos
gemots93712153_gemots
glamors1068123glamors
glamour1065143glamour
glamours1184743glamours
glomus9468093_glomus
grampus12356313grampus
grumous1086613grumous
gummous1236263gummous
iambus10468903_iambus
igneous835773igneous
infamous1354543infamous
isogamous1243753isogamous
jealous1438093jealous
magalogs1245253magalogs
manganous1245763manganous
marabous1249063marabous
miaous8511693mia_ous
ogams84112683ogam__s
osmous8138183_osmous
paramos113213513paramo_s
paramour1246083paramour
paramours1345653paramours
parous84024163_parous
racemous1246953racemous
ramus76418283_ram_us
rhamnus1233133rhamnus
rimous8311913_rimous
sagacious1244673sagacious
sagamore1144353sagamore
sagamores1244193sagamores
sajous13310583_sajous
sapajous1744833sapajous
shamois123210423shamois
shamos114216983shamo_s
shamoys15367283shamoys
shamus114112813sham_us
spumous1135853spumous
squamous1944673squamous
syngamous1543393syngamous
tinamous1045983tinamous
unfamous1344293unfamous
uranous7310733uranous
vagarious1344613vagarious
vanadous1246033vanadous
wammus13426733_wammus
wampus13499013_wampus
wamus105514683_wam_us
zealous1637813zealous

Search took 8 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.406440125.6
2DLD Change Limit1340271716.68620045.9
3Display Results1711710.0632714.3
 (SQL Overall)1786911717.15524974.3
 
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.