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

108 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
nonacting123878(None) 
coacting133412702co_acting
coenacting1545872coenacting
contacting15610072contacting
donating10311802dona_ting
enacting11311362_enacting
nonaction1149442nonaction
nonactions1248372nonactions
nonactive1448972nonactive
nonbiting1247822nonbiting
noncaking1646682noncaking
noncling11310762non_cling
nonvoting1346902nonvoting
notating92513342nota_ting
acting95920983___acting
boasting113512503bo_asting
boating103721303bo_a_ting
bogarting1334653bogarting
bonneting1236173bonneting
borating113414503bora_ting
coaching164011963co_aching
coapting133511613co_apting
coasting113615513co_asting
coating103525313co_a_ting
compacting19177093compacting
concaving1737353concaving
concocting1448413concocting
conducting1648833conducting
confecting18310553confecting
confuting1539093confuting
connecting15310383connecting
connoting12310023connoting
contracting16610473contracting
convecting18310433convecting
convicting1847583convicting
doating93816863do_a_ting
exacting1838523_exacting
impacting1635943impacting
infracting1647353infracting
intonating1148633intona_ting
iodating1038823ioda_ting
knacking14296713_knacking
locating11311503loca_ting
manacling1446283manacling
menacing1339783menac_ing
misacting1439083misacting
moating104218153mo_a_ting
negating102012833nega_ting
nidating1039783nida_ting
nocking143615113no__cking
nominating1349503nomina_ting
nonacid101210843nonac_i_d
nonacids11148263nonac_ids
nonactor1047773nonact_or
nonactors1147873nonactors
nonartist949423nonartist
nonbanking1743733nonbanking
nonbeing1137053non_being
nonbetting1345843nonbetting
nonbuying1543953nonbuying
noncoding1347673noncoding
noncoking1646813noncoking
nondrying1444683nondrying
nonearning1145183nonearning
nonending1138003nonending
nonfading1445873nonfading
nonflying1643673nonflying
nonhunting1444683nonhunting
nonjuring1756053nonjuring
nonliving1346763nonliving
nonloving1345413nonloving
nonmeeting1346073nonmeeting
nonmoving1545103nonmoving
nonpaying1545713nonpaying
nonrioting1146753nonrioting
nonruling1046433nonruling
nonsuiting1147273nonsuiting
nonteaching1753583nonteaching
nonusing939233non_using
notching14288583no_tching
noticing1139453notic_ing
noting74120153no___ting
nutating92411953nuta_ting
orating83520323_ora_ting
outacting1239213outacting
ozonating1944323ozona_ting
phonating1537813phona_ting
poaching163510833po_aching
poncing122913583pon_c_ing
preacting142412533preacting
pronating12313763prona_ting
reacting113317893_reacting
redacting13612303redacting
reenacting1357353reenacting
roaching143210433ro_aching
roasting93012703ro_asting
rotating92614553rota_ting
snacking153411703_snacking
solacing11310133solac_ing
solating9315593sola_ting
sonatina849073sona_tina
sonatine8313323sona_tine
sonicating1348313sonicating
sonneting1037003sonneting
tenanting1036213tenanting
tincting1148883tin_cting
toasting93410583to_asting
wonting113214103won__ting

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 Limit1486411087.12620859.0
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.62523434.9
 
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.