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

74 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
nonactor104777(None) 
nonactors1147871nonactors
nonfactor1445271nonfactor
coactor1139122co_actor
cofactor1545752cofactor
contactor1348432contactor
donator8310262dona_tor
enactor938032_enactor
nonaction1149442nonaction
nonauthor1252362nonauthor
nondoctor1245172nondoctor
nonfactors1545332nonfactors
nonreactor1254032nonreactor
nonvector1445792nonvector
actor71116073___actor
coactors1239473co_actors
coanchor1545253coanchor
cofactors1645933cofactors
compactor17256023compactor
concoctor1246323concoctor
conductor1447213conductor
connector1347923connector
contactors1448843contactors
contractor1449073contractor
convector1648083convector
copastor1246343copastor
doctor938993do__ctor
donators9310403dona_tors
enactors1038453_enactors
enactory1346143_enactory
exactor1636623_exactor
factor11911453__factor
functor1235203fun_ctor
impactor14265003impactor
infractor1465943infractor
locator93110423loca_tor
monitor9310723mon_itor
negator83010673nega_tor
nominator1157823nomina_tor
nonacid101210843nonac_id
nonacids11148263nonacids
nonacting1238783nonacting
nonactions1248373nonactions
nonactive1448973nonactive
nonagon847313nona_gon
nonart6319193nonart__
nonarts7311303nonart_s
nonauthors1352523nonauthors
noncolor1046513noncolor
noncom1039683non_c_om
noncore9411953non_c_ore
nondoctors1345293nondoctors
nonfact1248893nonfact__
nonfacts1346073nonfact_s
nonjuror15113803nonjuror
nonlabor1044843nonlabor
nonmajor1743663nonmajor
nonmetro1045373nonmetro
nonpoor956483non_poor
nonreactors1354063nonreactors
nonstop9106923non_stop
nonstory1148103non_story
nonvectors1556283nonvectors
nonvoter1186893nonvoter
orator6314533_ora_tor
pronator10311783prona_tor
reactor93011653_reactor
redactor1147023redactor
reenactor1184353reenactor
rotator7310833rota_tor
senator7313073sena_tor
sonicator1197263sonicator
tractor9311333_tractor
varactor1345683varactor

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 Filter1786911461620.406440125.6
2DLD Change Limit146162747.29620033.2
3Display Results74740.0164625.0
 (SQL Overall)178691747.71823152.5
 
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.