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 “nonaction” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
nonaction114944(None) 
nonactions1248371nonactions
coaction12310772co_action
conation101420882cona_tion
donation91513782dona_tion
inaction1039622_inaction
nonacting1238782nonacting
nonactive1448972nonactive
nonactor1047772nonact_or
nonfiction1546302nonfiction
notation81414602nota_tion
novation111710012nova_tion
zonation171410722zona_tion
action84719683___action
adnation9310783adna_tion
agnation9311723agna_tion
bolection13117673bolection
coactions1349743co_actions
cognation12310753cogna_tion
compaction1846753compaction
conations111318903cona_tions
concoction1348233concoction
condition12411163condition
conduction1549963conduction
confection17411183confection
connation11314263connation
connection14410533connection
contraction15411243contraction
convection17411123convection
conviction1748183conviction
donations101112353dona_tions
dotation91412733dota_tion
enation73419233_ena_tion
exaction1738953_exaction
faction122613333__faction
fraction1359483_fraction
function1337843fun_ction
impaction1545733impaction
inactions1139323_inactions
infraction1557453infraction
intonation10410263intona_tion
inunction1146893inun_ction
iodation9310383ioda_tion
junction1736203jun_ction
lobation102110553loba_tion
location102113913loca_tion
lunation8311923luna_tion
monition10311723mon_ition
natation81513933nata_tion
nation64322803__na_tion
negation92913023nega_tion
nidation9410583nida_tion
nomination12712103nomina_tion
nonacid101210843nonac_i_d
nonacids11148263nonac_ids
nonactors1147873nonactors
nonagon847313nona__gon
nonartist949423nonartist
nonauthor1252363nonauthor
nonelection1347203nonelection
nonfactor1445273nonfact_or
nonfictions1645933nonfictions
nonillion945463nonillion
nonunion845583non_union
notations91512973nota_tions
notion64516583no___tion
novations12139003nova_tions
nunnation9126563nunnation
nutation81513103nuta_tion
olfaction1464233olfaction
oration71617713_ora_tion
ovation101510023_ova_tion
ozonation1845673ozona_tion
paction112713963__paction
phonation1439393phona_tion
potation101716783pota_tion
proaction13410103proaction
pronation11415703prona_tion
reaction10612603_reaction
redaction1259663redaction
rogation91612053roga_tion
rotation81615453rota_tion
sanction1049533san_ction
solation8916153sola_tion
sonication12411183sonication
taction93213023__taction
traction10412683_traction
unction9310663_un_ction
venation11513503vena_tion
vocation132311983voca_tion
zonations18139313zona_tions

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 Filter1786911486410.453394461.4
2DLD Change Limit148641916.89021573.4
3Display Results91910.0461978.3
 (SQL Overall)178691917.38924183.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.