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

224 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
incanted1125954(None) 
incented112412541incented
canted94825782__canted
decanted122310492decanted
discanted1339332discanted
enchanted1546552enchanted
incaged114010442inca_ged
incant82418512incant__
incants92012802incant_s
incarnated1355812incarnated
incased103612392inca_sed
incensed11277952incensed
incenter102212092incenter
incepted13177782incepted
incited103314622inc_ited
indented101811732indented
infante101910882infante_
infantes11249632infantes
invented122510662invented
recanted112513512recanted
scanted104114392_scanted
uncanned11289962uncanned
uncarted11312052uncarted
unwanted12249602unwanted
accented13107773accented
andante8311273andante_
andantes9310853andantes
anointed938343anointed
ansated84214003ansa_ted
anted66328243___anted
caned85838093__can_ed
canned95022063__canned
canoed94618963__canoed
canter85230113__canter
carted98631443__carted
catted95422473__catted
chanted134015953_chanted
decanter112510793decanter
descanted1336673descanted
enacted10310643en_acted
encaged113211083enca_ged
encamped1535033encamped
encased103512323enca_sed
encashed14246483encashed
enchanter1446193enchanter
encysted1444303encysted
enhanced1436623enhanced
financed1435123fin_anced
granted94715103_granted
hanted104124313__hanted
ideated9310973idea_ted
impacted15286353impacted
impainted1454773impainted
imparted13248063imparted
impasted13297553impasted
implanted1475493implanted
inane52820343in_an_e_
inaner62213543in_an_er
inanes62519803in_an_es
inarmed10268673in_armed
incage93513623inca_ge_
incages103013883inca_ges
incanting1289903incanting
incarnate1157223incarnate_
incarnates1246713incarnates
incase83615283inca_se_
incases93615973inca_ses
incense92410303incense_
incenses102411003incenses
incent83320723incent__
incenters112510303incenters
incents92414533incent_s
inched124514483inc__hed
incised102911583inc_ised
incite83618733inc_ite_
inciter93113773inc_iter
incites93218483inc_ites
inclasped1463553inclasped
inclined1138643inclined
inclosed1197623inclosed
included1234833included
incrusted12125853incrusted
incubated1446983incubated
incurred1136493incurred
incurved1435313incurved
incused102911173inc_used
indagated1245573indagated
indebted12246873indebted
indenter92311443indenter
indicated13310953indica_ted
indicted1249203indicted
indited93515023in_dited
inducted1237273inducted
inearthed1343623inearthed
inedited10278993inedited
infant92315133infant__
infanta10237253infant_a
infantas11246003infantas
infantry1443853infantry
infants102210773infant_s
infarcted1544243infarcted
infected14229403infected
infested12249643infested
inflated12410863inflated
infracted1546363infracted
ingate73018243inga_te_
ingates82716913inga_tes
ingested10259003ingested
ingoted939183in_goted
ingrafted1444423ingrafted
inhabited1544673inhabited
inhaled1169333inha_led
injected18226753injected
inlaced10239873inla_ced
inland7310313inlan__d
inlander937223inlander
inmate82917363inma_te_
inmates92715783inma_tes
innate63917313inna_te_
inned64118423in__n_ed
inputted1134663inputted
insane6314893insan_e_
insaner7310443insan_er
inserted92413053inserted
insetted9249023insetted
insisted998673insisted
insnared956123insnared
inspanned1242853inspanned
instanced1245703instanced
instanter946243instanter
instated91613343instated
insulted937193insulted
intended102310413intended
intonated1048303intonated
intoned8811993inton_ed
intorted9310123intorted
intuited938763intuited
inurned8328053inurn_ed
invaded12127043inva_ded
invected14258883invected
inventer112410843inventer
inverted122312163inverted
invested12229693invested
invited113612463in_vited
invocated1546203invoca_ted
inwalled1275773inwalled
iodated9310023ioda_ted
islanded1035513islanded
levanted1245323levanted
lineated9711063linea_ted
located103114183loca_ted
nictated1137793nictated
nidated939863nida_ted
nuanced1036203_nuanced
panted95024823__panted
picante11310523picante_
pinnated11338553pinna_ted
planted103516123_planted
quanted1738963_quanted
ranted74324703__ranted
recaned102817203recan_ed
recanter101913153recanter
scanned104110893_scanned
scanter94215183_scanter
scarted104816123_scarted
scatted103512773_scatted
scented102811883_scented
sinuated938413sinua_ted
slanted83514743_slanted
tenanted937043tenanted
tincted1037273tinc__ted
truanted935373truanted
unacted10312733un_acted
unbanded123010563unbanded
unbanned11279113unbanned
unbasted112510073unbasted
unbated103317733unba_ted
uncaged113314123unca_ged
uncaked143514353unca_ked
uncalled11810923uncalled
uncandid1244603uncandid
uncandled1345993uncandled
uncapped1556693uncapped
uncarded12310133uncarded
uncarved1438163uncarved
uncased104216953unca_sed
uncashed14299763uncashed
uncasked15278453uncasked
uncaused1138453uncaused
unchanged1636283unchanged
uncharted1538083uncharted
uncoated11314963uncoated
uncounted1238523uncounted
uncrated11416313uncrated
undated93118463unda_ted
undaunted1145453undaunted
undented102313953undented
ungated92717213unga_ted
unhanded132910183unhanded
unhanged13258833unhanged
unhatted1238183unhatted
unmanned11268603unmanned
unmated103317023unma_ted
unmatted1138293unmatted
unpainted1237183unpainted
unparted11310823unparted
unplanted1236853unplanted
unranked1338563unranked
unrated82621553unra_ted
unrented92413923unrented
unsalted9510923unsalted
unsated83419933unsa_ted
unscanned1245133unscanned
unscented1237513unscented
untainted1038423untainted
untanned9279963untanned
untasted92011573untasted
untented92613413untented
unwasted12259783unwasted
unwonted12248643unwonted
vacated1349353vaca_ted
wanted104319723__wanted
zincate1838533zinca_te_
zincates1937743zinca_tes

Search took 9 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.420425454.8
2DLD Change Limit1461622247.65619091.2
3Display Results2242240.0932408.6
 (SQL Overall)1786912248.16921874.3
 
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.