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

163 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
agnized1824722(None) 
agenized19257731agenized
agnize16329561agnize_
agnizes17328841agnizes
agonized19258991agonized
agatized1947072agatized
agenize172910152agenize_
agenizes18269742agenizes
agonised10248482agonised
agonize172911402agonize_
agonizes182610582agonizes
cognized2136292cognized
ignited9137622ignited
ionized172611292ionized
paganized2247162paganized
abided105313313a_bided
acned87520673acn__ed
admired1135703admired
admixed1833733admixed
advised12136043advised
adzed166012543a__dzed
aeried74221863aeri_ed
affined1436413affined
affixed2134123affixed
agatize1739833agatize_
agatizes1838863agatizes
agaze156113663ag_aze_
aged67334253ag___ed
agented939423agented
aggie73415013aggi_e_
aggies83515513aggi_es
agile65122263ag_ile_
aginner844663aginner
agisted938203agisted
agnate73314883agnate_
agnates82813193agnates
agnizing1936833agnizing
agnomen1036763agnomen
agonies83016623agoni_es
agonise83112693agonise_
agonises92613163agonises
agreed84712503ag_reed
aided75828933a__ided
ailed66240283a__iled
aimed85626053a__imed
aired66032923a__ired
alined75221403a_lined
aliped95414283a_liped
allied74217153alli_ed
amazed18519313a_mazed
aneled74719283a_neled
angeled93211513angeled
angered93013473angered
angled84219093a_ngled
anile54634463a_nile_
anime75423203a_nime_
animes84719593a_nimes
anise55129703a_nise_
aniseed839403a_niseed
anises64826693a_nises
ankled114313483a_nkled
annexed1535753annexed
annoyed1185873annoyed
anodized1946463anodized
anted66328243a_n_ted
anteed75616113a_nteed
antired82316193antired
anviled1138953anviled
apprized2236543apprized
arabized2047173arabized
ariled75620323a_riled
arrived11127353arrived
aspired1068173aspired
assize1538633assize_
assizes1638453assizes
atomized20279323atomized
attired8238913attired
audited939033audited
availed1135973availed
avianized2245083avianized
avoided1235553avoided
awaited1146963awaited
awned96615953awn__ed
awninged1342433awninged
axised14438963a_xised
azotized1745673azotized
bagpiped1642063bagpiped
baptized2245483baptized
canonized2147683canonized
caponized2347073caponized
capsized2255493capsized
cognised1256313cognised
cognize1957683cognize_
cognizer2055863cognizer
cognizes2058033cognizes
denied84318633deni_ed
denimed1159233denimed
denizen1737663denizen
ebonized2036973ebonized
engined9119893engined
frized193510683_frized
gained84617463_gained
gaited84416923_gaited
ganged94619193gan_ged
gazed165520333_g_azed
gibed96215963_g_ibed
gied64631983_g_i_ed
ginned83813983_ginned
glazed174711773_glazed
glided94513903_glided
glimed105312283_glimed
glitzed18375493_glitzed
glozed173711223_glozed
gnawed11427833_gnawed
grazed174115913_grazed
grided95117043_grided
grimed104714093_grimed
griped104114713_griped
guided94014113_guided
guiled84315383_guiled
guised84612173_guised
honied104818393honi_ed
ignified1386213ignified
ignite71410583ignite_
igniter8147673igniter
ignites81310583ignites
ignored9226443ignored
iodized18969163iodized
ionised82911493ionised
ionize154613873ionize_
ionizer162310123ionizer
ionizes162813343ionizes
ironized1858203ironized
japanized2844733japanized
jargonized2844343jargonized
knifed14528123_knifed
kyanized25224553kyanized
laicized2046043laicized
latinized1988533latinized
lenited8812433lenited
lionized1837023lionized
magnetized23457683magnetized
magnified1645763magnified
monied94319463moni_ed
nided75920873__nided
nixed135714223__nixed
organized2047543organized
ozonized1745113ozonized
paganised1346623paganised
paganize2048633paganize_
paganizer2145763paganizer
paganizes2148663paganizes
patinized2178823patinized
ponied94920703poni_ed
prized184415393_prized
resized174614903resized
salinized1947383salinized
seized164313653_seized
sized155519243__sized
sniped94913483_sniped
united74421543_united
unsized172510543unsized
upsized19246253upsized

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.390458182.1
2DLD Change Limit1340271636.84319586.0
3Display Results1631630.0463543.5
 (SQL Overall)1786911637.27924548.8
 
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.