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

90 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
nonactions124837(None) 
nonaction1149441nonaction_
coactions1349742co_actions
conations111318902cona_tions
donations101112352dona_tions
inactions1139322_inactions
nonacting1238782nonacti_ng
nonactors1147882nonact_ors
nonfictions1645932nonfictions
notations91512972nota_tions
novations12139002nova_tions
zonations18139312zona_tions
actions94218513___actions
adnations1039753adna_tions
agnations10310033agna_tions
bolections14137293bolections
coaction12310773co_action_
cognations1339593cogna_tions
compactions1946543compactions
conation101420883cona_tion_
concoctions1448263concoctions
conditions13410103conditions
conductions1649663conductions
confections18411393confections
connations12312943connations
connections15410703connections
contractions16410403contractions
convections18411493convections
convictions1848053convictions
donation91513783dona_tion_
dotations101411633dota_tions
enations83316903_ena_tions
exactions1838923_exactions
factions133013063__factions
fractions1449103_fractions
functions1437743fun_ctions
impactions1645413impactions
inaction1039623_inaction_
infractions1646963infractions
intonations1149523intona_tions
inunctions1246753inun_ctions
iodations1039113ioda_tions
junctions1835943jun_ctions
lobations11219613loba_tions
locations112512743loca_tions
lunations9310723luna_tions
monitions11310883mon_itions
natations91412493nata_tions
nations74720563__na_tions
negations102811963nega_tions
nidations1039213nida_tions
nominations13410533nomina_tions
nonacids11148263nonac_i_ds
nonactive1448973nonacti_ve
nonactor1047783nonact_o_r
nonagons947223nona__gons
nonartists1046403nonartists
nonauthors1352523nonauthors
nonelections1456393nonelections
nonfactors1545333nonfact_ors
nonfiction1546303nonfiction_
nonillions1045263nonillions
nonunions945583non_unions
notation81414603nota_tion_
notions74014483no___tions
novation111710013nova_tion_
nunnations1095903nunnations
nutations91411763nuta_tions
olfactions1563873olfactions
orations81515803_ora_tions
ovations11149263_ova_tions
ozonations1945143ozona_tions
pactions122613503__pactions
phonations1538313phona_tions
potations111615073pota_tions
proactions1449343proactions
pronations12314033prona_tions
reactions11711713_reactions
redactions1359133redactions
rogations101510823roga_tions
rotations91613843rota_tions
sanctions1138873san_ctions
solations9814623sola_tions
sonications1349953sonications
tactions102912423__tactions
tractions11511623_tractions
unctions1039733_un_ctions
venations12311723vena_tions
vocations141911423voca_tions
zonation171410723zona_tion_

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 Filter1786911406030.406440125.6
2DLD Change Limit140603906.78320728.7
3Display Results90900.0461956.5
 (SQL Overall)178691907.23524698.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.