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

168 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
captured133657(None) 
capture1138911capture_
capturer1246091capturer
captures1239441captures
raptured1155461raptured
cantered113415982cantered
capered123014042cap_ered
capsuled1334532capsuled
capturers1344632capturers
catered103117772ca_tered
chaptered17176792chaptered
clotured11246162clotured
cultured1137232cultured
matured10310032ma_tured
natured838962na_tured
pastured1138232pastured
rapture937382rapture_
raptures1037572raptures
recaptured1573592recaptured
ruptured1144682ruptured
vapoured1434352vapoured
abjured1735083_abjured
adjured1634883_adjured
allured8299173_allured
altered83215733_altered
antired82316193_antired
apertured1244063_apertured
assured858373_assured
attired8238913_attired
attuned835173_attuned
augured987193_augured
bantered113313633bantered
baptised1335263baptised
baptized2245483baptized
bartered113113013bartered
battered113315053battered
cactuses1237933cactuses
caftaned1445093caftaned
calibred1335053calibred
callused1135853callused
calqued19306523calqu_ed
cambered15129003cambered
campused1535253campused
cancered132411553cancered
cankered153010223cankered
canted94825783cant__ed
cantoned111411523cantoned
caped104931803cap___ed
caperer113013403cap_erer
capitated14159043capitated
capped134721853cap__ped
capsized2255493capsized
capsule1137343capsule_
capsules1236623capsules
captained1446193captained
captioned1445763captioned
captive1438973captive_
captives1538623captives
captor104914603captor__
captors113914983captor_s
capturing1436623capturing
capuched1843743capuched
carburet12411113carburet
cared86050093ca___red
careered1139493careered
caroused1149253caroused
carted98631443cart__ed
cartoned111312833cartoned
casqued19235633casqu_ed
castled104311513cast_led
caterer92815943ca_terer
catted95422473ca_t_ted
caucused1344093caucused
caused95117043ca__used
censured11248913censured
centered112513523centered
centred103411683cent_red
chartered15158393chartered
chattered15197993chattered
cinctured1444273cinctured
ciphered1637053ciphered
clamoured1444073clamoured
clattered12178403clattered
closured11266353closured
cloture9238453cloture_
clotures10299023clotures
cloured103111543c_loured
coapted123911503coapt__ed
coloured1148313coloured
conjured18117903conjured
contoured1237303contoured
contused1138443contused
coppered153410543coppered
costumed1365033costumed
cottered112511733cottered
couture9310623couture_
coutures10311993coutures
cratered1149683cratered
culture939393culture_
cultures10310153cultures
cured85932133c___ured
cyphered1934653cyphered
enraptured1352383enraptured
factored1436213factored
facture12108923facture_
factures13129023factures
faltered122810983faltered
favoured1533963favoured
featured1237683featured
fractured15125043fractured
gartered10319583gartered
gestured1036993gestured
hachured1744393hachured
haltered123112553haltered
hatred104814333ha_t_red
inpoured1135813inpoured
laboured1156323laboured
lappered13288213lappered
lectured11127223lectured
manured1039473ma_nured
martyred1434283martyred
mastered112614003mastered
mattered112412903mattered
mature8313463ma_ture_
maturer938973ma_turer
matures9314303ma_tures
nattered92011623nattered
nature6311263na_ture_
natures7311963na_tures
nurtured935253nurtured
paltered113012483paltered
papered122513173pap_ered
pastored1139963pastored
pasture9311463pasture_
pasturer1037523pasturer
pastures10311963pastures
pattered112714203pattered
pictured1346573pictured
postured1139493postured
poured95116743__poured
raftered1237663raftered
rapiered1136053rapiered
recapture1384713recapture_
recaptures1474463recaptures
repoured1139563repoured
rupture966163rupture_
ruptures1056683ruptures
savoured1234793savoured
scattered12197353scattered
sceptered1444723sceptered
sceptred1343653scept_red
sculptured1542743sculptured
sutured8310373_sutured
taboured1156273taboured
tapered102612933tap_ered
tattered92011443tattered
textured1695483textured
tortured935843tortured
upturned11214013_upturned
vapored1336923vap_ored
vapourer1344263vapourer
ventured1238273ventured
vestured1237463vestured
wafture1334853wafture_
waftures1434853waftures
waitered1238753waitered
watered113014953wa_tered
yattered12239533yattered

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 Limit1461621686.93621073.0
3Display Results1681680.0762210.5
 (SQL Overall)1786911687.41824088.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.