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

140 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
agonists928983(None) 
agonises92613161agonises
agonist82615401agonist_
agonistes10266261agonistes
adonises92611432adonises
ageists848492ag_eists
agists75713172ag__ists
agonies83016622agoni_es
agonise83112692agonis_e
agonised10248482agonised
agonistic1246682agonistic
agonizes182610582agonizes
amorists10411332amorists
aorists74215832a_orists
arsonists947412arsonists
atomists102610962atomists
canonists1158512canonists
egoists887072ego_ists
egotists937062egotists
ironists839292ironists
jargonists1844432jargonists
monists93614782_monists
paganists1247642paganists
ableists1036543ableists
aconite9315473aconi_te
aconites10314353aconites
adonis7314063adoni__s
against838383against_
ageisms1056603ag_eisms
ageist7315383ag_eist_
ageneses939303ageneses
agenesis938043agenesis
agenizes18269743agenizes
agents74816293agen__ts
agisms9399393ag__isms
agist66325583ag__ist_
agnizes17328843ag_nizes
agnosias947243agnosias
agones75719863agon__es
agonic93515143agoni__c
agonising1146573agonising
agonize172911403agoni_ze
agonized19258993agonized
agons66423783agon___s
agronomists1453793agronomists
algorisms1246173algorisms
alienists946913alienists
alpinists1195793alpinists
altoists848753altoists
amongst1045363amongst_
amorist9317643amorist_
angsts738863a__ngsts
animists103010633animists
anises64826693a__nises
anoints7311063ano_ints
antagonists1294803antagonists
aorist64827873a_orist_
aphorists1448263aphorists
apomicts1444193apomicts
arborists1147453arborists
argonauts1043403argonauts
aroints7313133aro_ints
arsonist8412013arsonist_
artists74215593a_rtists
assists738473a_ssists
atavists1137583atavists
atheists1138713atheists
atomises103514403atomises
atomisms12269573atomisms
atomist92915763atomist_
atonalists1048493atonalists
atonias73315993atoni_as
atonics93613713atoni_cs
atonies75320953atoni_es
aurists74615783a_urists
autists73814853a_utists
azotises1737603azotises
canoeists1147163canoeists
canonises11410803canonises
canonist10513533canonist_
clonisms1237793clonisms
cognises11610043cognises
colonists112512503colonists
consists10310593_consists
crayonists1544133crayonists
demonists1248703demonists
ebonises1039223ebonises
egoisms1065953ego_isms
egoist7612283ego_ist_
egotisms1146683egotisms
egotist8411273egotist_
eonisms92811043_eonisms
eugenists1046173eugenists
florists1138813florists
foists95413983_fo_ists
gists66026193_g__ists
gnomists1145473gnomists
goniffs14473903_goniffs
gonifs104310133_goni_fs
grists74716483_g_rists
hagadists1445073hagadists
harmonists15137123harmonists
hedonists1346053hedonists
hoists95516023_ho_ists
holists104413963_holists
hornists11208833hornists
hymnists1644903hymnists
ionises72916433_ionises
ironist7314843ironist_
jargonist1746703jargonist_
joists134711033_jo_ists
laconisms1347013laconisms
lionises8310313lionises
lookists1245713lookists
mammonists13144653mammonists
monisms113512803_monisms
monist84324983_monist_
oboists937903obo_ists
odists749853__odists
ologists939443ologists
onanists838413onanists
organists1047383organists
ozonises1776373ozonises
paganises1239723paganises
paganisms1447933paganisms
paganist11411813paganist_
parodists1248513parodists
peonisms1238443peonisms
pianists1049013pianists
plenists1038253plenists
protists10313363protists
rigorists1045673rigorists
sarodists1056593sarodists
satanists948233satanists
simonists1146763simonists
tanists7313653_tanists
tennists8297793tennists
unionists946213unionists
utopists1045773utopists
violists1137663violists

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621406.36022981.4
3Display Results1401400.0632222.2
 (SQL Overall)1786911406.84326113.0
 
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.