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

226 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
agonises9261316(None) 
adonises92611431adonises
agonies83016621agoni_es
agonise83112691agonise_
agonised10248481agonised
agonistes10266261agonistes
agonists9289831agonists
agonizes182610581agonizes
aconites10314342aconites
ageneses939302ageneses
agenizes18269742agenizes
agnizes17328842ag_nizes
agones75719862agon__es
agonist82615402agonis_t
agonize172911402agonize_
agonized19258992agonized
anises64826692a__nises
atomises103514402atomises
atonies75320952atoni_es
azotises1737602azotises
canonises11410802canonises
cognises11610042cognises
ebonises1039222ebonises
ionises72916432_ionises
lionises8310312lionises
ozonises1776372ozonises
paganises1239722paganises
abatises10311013abatises
abolishes1446053abolishes
abscises1246233abscises
aconite9315473aconite_
adenines9310193adenines
adenoses947903adenoses
admonishes1643493admonishes
adonis7314063adoni__s
advises11138973a_dvises
aegises8311373a_egises
agaroses938823agaroses
agatizes1838863agatizes
ageisms1056603ag_eisms
ageists848493ag_eists
agencies1138743agencies
agenes74720253agen__es
agenesis938043agenesis
agenize172910153agenize_
agenized19257733agenized
agentives1346443agentives
aggies83515513ag_gi_es
agisms9399393ag__isms
agists75713173ag__ists
agnates82813183ag_nates
agnize16329563ag_nize_
agnized18247223ag_nized
agnosias947233agnosias
agone65924553agon__e_
agonic93515143agoni__c
agonising1146573agonising
agonistic1246673agonistic
agons66423783agon___s
agouties9337693agouties
alanines8314793alanines
algorisms1246173algorisms
alunites8310703alunites
ammonites1348133ammonites
amorists10411323amorists
amortises1178823amortises
amosites10311233amosites
animes84719593a__nimes
anise55129703a__nise_
anodizes1837963anodizes
anomies93316983anomi_es
anuses66218773a__nuses
aorists74215823a_orists
aphorises14310003aphorises
apoapses1244713apoapses
apodoses1136653apodoses
apomixes1934853apomixes
apprises12310963apprises
aragonites1145803aragonites
arenites8917103arenites
arginases1046373arginases
arginines1047053arginines
argosies939523argosi_es
arises65233803a__rises
arouses74921293aro_uses
arrises71617583a_rrises
arsonists947413arsonists
aspises9611643a_spises
astonies8815093astoni_es
astonishes1344533astonishes
atomies93918363atomi_es
atomise93013823atomise_
atomised11278833atomised
atomiser10268153atomiser
atomisers11255453atomisers
atomisms12269573atomisms
atomists102610953atomists
atomizes192711423atomizes
atones65225773aton__es
atonias73315993atoni_as
atonics93613713atoni_cs
atopies92816433atopi_es
avenses1049643aven_ses
avodires1244123avodires
axises134413993a__xises
axonemes1744333axonemes
axones134614513axon__es
azotise1637073azotise_
azotised1844443azotised
azotizes1636853azotizes
baronies10315023baroni_es
bonuses94212953_bonuses
boonies93422483booni_es
canonise10511093canonise_
canonised1256713canonised
canonists1158513canonists
canonizes2049593canonizes
caponizes2238703caponizes
clonisms1237793clonisms
clonuses1057133clonuses
cognise1059683cognise_
cognised1256313cognised
cognizes2058023cognizes
colonises112814013colonises
conies84338593_coni_es
conines93827793_conines
conioses10313313_conioses
cronies9622503croni_es
demonises12311093demonises
ebonies9312883eboni_es
ebonise939613ebonise_
ebonised1136043ebonised
ebonites1039223ebonites
ebonizes1938073ebonizes
egises7312493eg__ises
egoisms1065953ego_isms
egoists887073ego_ists
egotisms1146683egotisms
egotists937063egotists
enosises8311003enosises
eonisms92811043_eonisms
finises10312903_finises
gahnites1235703gahnites
gaposises1245523gaposises
garnishes13198813garnishes
geneses82613523_geneses
genies75324943_geni_es
geniuses935933_geniuses
genoises939253_genoises
genuses83510883_genuses
gnoses76515163_g_noses
gobies95418053_gobi_es
goniffs14473903_goniffs
gonifs104310133_goni_fs
goonies83618333gooni_es
gooses75723053_go_oses
gorses74723293_go_rses
guises74216313_g_uises
gunites8313123_gunites
haggises1335883hag_gises
harmonises15148373harmonises
hognoses12108133hognoses
hoises94823673_ho_ises
idolises938763idolises
ignites81310573ig_nites
iodises83413633_iodises
ionise63516933_ionise_
ionised82911493_ionised
ionizes162813343_ionizes
ironies7517423ironi_es
ironists839293ironists
ironizes17510373ironizes
jargonists1844433jargonists
jargonizes2745103jargonizes
joneses1438963_joneses
kyanises15206393kyanises
laconisms1347013laconisms
lionise7310373lionise_
lionised946603lionised
lioniser845573lioniser
lionisers944163lionisers
lionizes1738773lionizes
loonies73919543looni_es
lorises73918593_lorises
masonites1149173masonites
monies83233163_moni_es
monishes13311483_monishes
monisms113512803_monisms
monists93614783_monists
moonrises1146723moonrises
noises65021853_no_ises
nonuses73313863_nonuses
onuses65616253__onuses
organises1048683organises
ozonides1854293ozonides
ozonise1646443ozonise_
ozonised1853893ozonised
ozonizes1636083ozonizes
paganise1139663paganise_
paganised1346623paganised
paganisms1447933paganisms
paganists1247643paganists
paganizes2148663paganizes
patronises1298433patronises
penises9318193_penises
peonies93620153peoni_es
peonisms1238443peonisms
phonies123717513phoni_es
poises84226543_po_ises
ponies84833463_poni_es
promises122916763promises
saponines1148043saponines
saponites1139933saponites
saxonies1537913saxoni_es
stonishes1247363stonishes
taconites1148463taconites
tennises82810133tennises
tonuses73612193_tonuses
toonies73719883tooni_es
unionises947153unionises
vaginoses1344143vaginoses
valorises122210173valorises
vaporises14209453vaporises
wagonages1443303wagonages
whosises1435333whosises
zoonoses1746203zoonoses

Search took 10 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 Filter1786911461620.1601116818.8
2DLD Change Limit1461622268.98316271.0
3Display Results2262260.0932430.1
 (SQL Overall)1786912269.23619347.2
 
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.