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

94 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
excitor164599(None) 
exciter1637751exciter
exciton1646081exciton
excitors1746091excitors
editor738662e_ditor
elicitor1045772elicitor
evictor12346362evictor
exactor1636632exactor
excimer1834962excimer
excite15310882excit_e
excited1737852excited
exciters1736322exciters
excites16310632excites
excitons1746042excitons
executor1744832executor
expiator1747042expiator
actor71116083_ac_tor
auditor837313auditor
citer74827333__citer
depictor1355513depictor
doctor938993doc_tor
ecotour944363e_cotour
editors839423e_ditors
educator1147153educator
eductor1035863eductor
ejector16378603ejector
elector93313263elector
elicitors1145803elicitors
enactor938043enactor
equator1637483equator
erector93513813erector
evertor1038723evertor
evictors13276853evictors
evocator1346573evocator
exacter1637403exacter
exaction1738953exaction
exactors1737023exactors
exalter1437563exalter
excavator2143653excavator
excerptor2063653excerptor
excide1638423exci_de
excided1836203excided
excides1738343excides
excimers1944703excimers
exciple1874683exciple
excise1538553exci_se
excised1736673excised
excises1638933excises
excision1746273excision
excitant1777353excitant
excitatory2254343excitatory
exciting1838023exciting
excitonic2043253excitonic
excreter1766123excreter
excretory2143463excretory
excuser1635813excuser
execrator1846563execrator
executer1745313executer
executors1844653executors
executory2143723executory
exhibitor2152753exhibitor
exiler134712183ex_iler
exit114428673ex_it__
exited144712523ex_ited
exits125515913ex_it_s
expeditor1943823expeditor
expiators1846803expiators
expiatory2145183expiatory
expirer1635993expirer
expositor1844153expositor
extol1247893ex__tol
extort13513973ex__tort
factor11911463fac_tor
genitor837273genitor
hector113312653hec_tor
heritor10310563heritor
ignitor8125263ignitor
incisor955323incisor
inciter93113773inciter
janitor1436483janitor
lector83514993lec_tor
lictor83610863lic_tor
locator93110423locator
monitor9310723monitor
reactor93011663reac_tor
reciter94117263reciter
rector84019753rec_tor
sector83415933sec_tor
servitor1145063servitor
suitor63311053_suitor
traitor7310123traitor
vector113212063vec_tor
victor113210673vic_tor
visitor1046203visitor

Search took 7 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.406440125.6
2DLD Change Limit134027946.40620922.1
3Display Results94940.0303133.3
 (SQL Overall)178691946.84226116.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.