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

173 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
exciting183802(None) 
exciding1935921exciding
excising1837211excising
exiting15311391ex_iting
citing94220182__citing
editing9313132e_diting
eliciting1237772eliciting
enditing10311072enditing
escoting1158712escoting
evicting1437482evicting
eviting11511372e_viting
exacting1838522exacting
exalting1638032exalting
excepting2145872excepting
excitant1777352excitant
excitingly2343182excitingly
exciton1646082exciton_
excitons1746042excitons
excreting1946432excreting
excusing1836502excusing
executing1945582executing
exerting162211152exerting
exiling15311082ex_iling
existing1639072existing
expiating1938542expiating
expiring1836252expiring
exulting1637642exulting
inciting11312532inciting
reciting113118072reciting
unexciting2042992unexciting
acting95920983_ac_ting
auditing1039033auditing
awaiting1238273awaiting
baiting103918883_baiting
biting95321823__biting
bruiting11259973bruiting
coting94629253__coting
debiting122511203debiting
deciding132210833deciding
depicting1537813depicting
despiting13179323despiting
ducting113713593duc_ting
easting84924303e_asting
eating75134403e__ating
eching126315563e_c_hing
echoing1358613e_choing
educating1337933educating
egesting1039013egesting
ejecting18268163ejecting
elating83423083e_lating
electing112113783electing
eliding93414343e_liding
eloining9310443eloining
eluting84115293e_luting
emaciating1546813emaciating
emailing113010043emailing
emceeing1343573emceeing
emitting112410353emitting
emoting10313563e_moting
enacting11311363enacting
encaging1258733encaging
encasing11610823encasing
encoding1239043encoding
encoring11312173encoring
encysting1544613encysting
engining1039293engining
enlisting1038343enlisting
ensiling9410723ensiling
enticing11311803enticing
entitling1037103entitling
equating18310113equating
erecting112415063erecting
eructing112110173eructing
erupting11218443erupting
escaping1347063escaping
escorting1237713escorting
estating92614993estating
etching134511843etc_hing
euchring1436613euchring
everting122213133everting
examining1945143examining
excavating2344113excavating
exceeding2043493exceeding
excelling1935643excelling
excerpting2244143excerpting
excessing1945713excessing
excipient2044483excipient
excision1746273excision
excisions1846383excisions
excitants1864393excitants
excite15310883excit__e
excited1737853excit_ed
exciter1637753excit_er
exciters1736323exciters
excites16310633excit_es
excitonic2043253excitonic
excitor1645993excit_or
excitors1746093excitors
exclaiming2243113exclaiming
excluding2043463excluding
excoriating2145483excoriating
execrating2047883execrating
exempting2144223exempting
exercising2044453exercising
exhaling1936293exhaling
exhibiting2343623exhibiting
exhorting2045733exhorting
exhuming2143303exhuming
exing136016813ex___ing
exorcising2044203exorcising
exorcizing2944163exorcizing
expecting2146693expecting
expediting2144643expediting
experting1938053experting
exploiting2044893exploiting
exporting1937323exporting
exposing1836673exposing
expositing2045353expositing
exscinding2142333exscinding
exsecting1935933exsecting
exserting1736663exserting
extincting2044003extincting
extorting1746763extorting
exuding16347443ex_uding
exuviating2144523exuviating
faceting1438783faceting
fliting113514613_fliting
fruiting12229063fruiting
gaiting93716583_gaiting
habiting1437533habiting
igniting1037363igniting
incising11411093incising
inditing10312113inditing
inviting1239733inviting
kiting114117093__kiting
leniting9312353leniting
lichting14268513lichting
limiting1138813limiting
locating11311503locating
meriting11314683meriting
misciting1439673misciting
orbiting1138153orbiting
penciling1437413penciling
picoting1338883picoting
plaiting113113513plaiting
positing11312303positing
preexciting2343753preexciting
quoiting1836093quoiting
reacting113317893reac_ting
rebaiting12311643rebaiting
reediting11310953reediting
reinciting1347103reinciting
requiting1939883requiting
resiting93521123resiting
respiting121912863respiting
reuniting10310693reuniting
rewriting13310413rewriting
siting74126623__siting
skiting123812503_skiting
smiting103014443_smiting
sopiting11310763sopiting
spiting103917623_spiting
suiting83419003_suiting
toiting83217093_toiting
uniting8315823_uniting
vacating14310353vacating
visiting1238393visiting
vomiting1437733vomiting
waiting113618953_waiting
whiting143311303_whiting
witing103522823__witing
writing113713893_writing
yachting1734933yachting

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.436409841.7
2DLD Change Limit1461621736.79621507.1
3Display Results1731730.0802162.5
 (SQL Overall)1786911737.31224438.0
 
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.