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

150 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
incanting128990(None) 
incenting12912061incenting
canting104725902__canting
decanting132510632decanting
discanting1449452discanting
enchanting1645942enchanting
incaging1288672inca_ging
incarnating1445542incarnating
incasing11610602inca_sing
incensing1297662incensing
incepting1489302incepting
inciting11312532inc_iting
indenting11911262indenting
infantine1247142infantine
inventing13109972inventing
recanting122414822recanting
scanting113914762_scanting
accenting1487833accenting
andantini1044563andantini
andantino1044893andantino
anointing1038623anointing
anting75827023___anting
caning94128623__can_ing
canning103620133__canning
cantina93417253__cantina
carting104228283__carting
casting104628343__casting
catting103922643__catting
chanting143413533_chanting
descanting1446923descanting
enacting11311363en_acting
encaging1258733enca_ging
encamping1645233encamping
encashing1536443encashing
encasing11610823enca_sing
encysting1544613encysting
enhancing1545823enhancing
financing1544073fin_ancing
granting103514523_granting
hanting114124483__hanting
ideating10311703idea_ting
impacting1635943impacting
impainting1544503impainting
imparting1437243imparting
impasting1436323impasting
implanting1545323implanting
inarming1138343in_arming
incant82418513incant___
incanted11259543incant_ed
incants92012803incant__s
incaution1146583incaution
incautions1245973incautions
incentive1489603incentive
inching134414323inc__hing
incising11411093inc_ising
inclasping1543803inclasping
inclining1248403inclining
inclosing1257663inclosing
including1344993including
incoming1349863inc_oming
incrusting13126473incrusting
incubating1597133incubating
incurring1236873incurring
incurving1545373incurving
incusing1159953inc_using
indagating1345263indagating
indicating1449693indica_ting
indicting1339613indicting
inditing10312113in_diting
inducting1338373inducting
inearthing1443543inearthing
infalling1356243infalling
infantile1245413infantile
infecting15109673infecting
infesting13109513infesting
inflating13310443inflating
infracting1647353infracting
ingesting11129623ingesting
ingoting1039863in_goting
ingrafting1544893ingrafting
inhabiting1644293inhabiting
inhaling1239523inha_ling
injecting1997693injecting
inlacing1158373inla_cing
inlaying1247893inla_ying
inletting1087873inletting
inning73617633in__n_ing
inputting1235823inputting
inserting10914243inserting
insetting1079283insetting
insisting1038823insisting
insnaring1046313insnaring
inspanning1343203inspanning
instancing1344643instancing
instating10812213instating
insulting1038053insulting
intending1139983intending
intonating1148633intonating
intoning9311123inton_ing
intorting10311413intorting
intuiting1089613intuiting
inurning937553inurn_ing
invading1336263inva_ding
inverting131013223inverting
investing13119393investing
inviting1239733in_viting
invocating1646333invoca_ting
inwalling1385633inwalling
inwinding1445173inwinding
iodating1038823ioda_ting
islanding1135623islanding
levanting1345523levanting
linecasting14102783linecasting
locating11311503loca_ting
miscasting1557073miscasting
nictating1237573nictating
nidating1039783nida_ting
panting104025423__panting
planting113515383_planting
quanting1849233_quanting
ranting84025413__ranting
recaning111416693recan_ing
recasting122414233recasting
scanning113310773_scanning
scantling12107233_scantling
scarting113415263_scarting
scatting113311813_scatting
scenting113212813_scenting
sinuating1039683sinua_ting
slanting94115093_slanting
tenanting1036213tenanting
tincting1148883tinc__ting
truanting1035603truanting
unbanning1235893unbanning
uncaging1268713unca_ging
uncaking1539463unca_king
uncapping1635133uncapping
uncaring11312843unca_ring
uncasing11511003unca_sing
unchanging1745223unchanging
uncoating12611923uncoating
uncrating12813183uncrating
unhanding1437203unhanding
unhanging1436363unhanging
unhatting1335873unhatting
unmanning1245873unmanning
unwaning1238133unwan_ing
upcasting1434823upcasting
vacating14310363vaca_ting
wanting114220173__wanting

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.420425454.8
2DLD Change Limit1486411506.69022218.4
3Display Results1501500.0602500.0
 (SQL Overall)1786911507.17024922.0
 
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.