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

143 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
casketed153495(None) 
basseted1136742basseted
cacheted16148232cacheted
cankered153010222cankered
carpeted1338952carpeted
caseated11310712caseated
casked134815512cask__ed
casket124820992casket__
caskets133910172casket_s
cosseted1178342cosseted
jacketed22146532jacketed
marketed1537322marketed
packeted17148282packeted
racketed15169122racketed
accreted1336333accreted
asked106919313_ask__ed
askeses1136463_askeses
assented957513_assented
asserted957903_asserted
basked135218603bask__ed
basket125722913basket__
basketry1743513basketry
baskets135111833basket_s
bassetted1244693bassetted
basted95227233bas__ted
blanketed1643913blanketed
bracketed1855863bracketed
bucketed1736763bucketed
cackled164613303cack_led
caked126128623ca_k__ed
calked134617403calk__ed
cambered15129003cambered
cameoed1238383ca_meoed
canceled13279403canceled
cancered132411553cancered
canted94825783ca__nted
cantered113415983cantered
capered123014043ca_pered
careened1139193careened
careered1139493careered
carked134024823cark__ed
carted98631443ca__rted
cascaded14135703cascaded
caseate9314783caseate_
caseates10313713caseates
cased86032413cas___ed
casefied1445943casefied
casemated1446953casemated
casette9310393cas_ette
casettes1039653casettes
cashed125124353cas__hed
cashiered1543403cashiered
casketing1635383casketing
casqued19235633cas_qued
cassene93111543cassene_
cassenes103611293cassenes
cassette1047813cassette
cassettes1146703cassettes
caste75932363cas__te_
caster85232573cas__ter
castes85631863cas__tes
castled104311513cas_tled
castrated1239513castrated
catered103117773ca_tered
cathected1744543cathected
catheter1338153catheter
catted95422473ca__tted
caudated1238063caudated
caveated1439133caveated
cavorted1435693cavorted
chapleted1743973chapleted
chastened1545883chastened
cisted95217523cis__ted
closeted1135613closeted
coasted104015953coas__ted
cockered17710213cockered
cockeyed2096123cockeyed
colleted113011663colleted
competed154113593competed
corseted11311473corseted
coshered14610293coshered
costed95623113cos__ted
coveted133011523c_oveted
cricketed1854683cricketed
crocketed1845123crocketed
curveted1435293curveted
cuspated1335913cuspated
dackered16116893dackered
daikered1495223daikered
darkened1435943darkened
docketed16156583docketed
easeled8159853eas_eled
faceted13509563fa_ceted
fasted105320953fas__ted
fastened12257853fastened
galleted1038213galleted
garreted1057523garreted
gasket114417253gasket__
gaskets12348153gasket_s
gasted84821583gas__ted
gusseted1043553gusseted
hankered16289443hankered
harkened1637483harkened
hasted105125283has__ted
hastened12239103hastened
hawkeyed2242403hawkeyed
isleted837523_isleted
junketed2033523junketed
kashered1636403kashered
lackered15108673lackered
lackeyed18104513lackeyed
lakebed1434783la_kebed
lanceted1137073lanceted
lappeted13255833lappeted
lasted74323603las__ted
marketer1437383marketer
masked134316523mask__ed
masseter1037063masseter
masted94025803mas__ted
mastered112614003mastered
palleted1139873palleted
pargeted1238683pargeted
pasted94426903pas__ted
picketed17167383picketed
pocketed17147143pocketed
rabbeted1334443rabbeted
racheted14149503racheted
rocketed15157793rocketed
sacheted14127833sacheted
skated114414883__skated
skeed105018983__ske_ed
skewed145610233__skewed
skited114313483__skited
socketed15177343socketed
tableted1137533tableted
targeted1037483targeted
tasked114714643task__ed
tasseled935593tasseled
tasted74123973tas__ted
ticketed15146643ticketed
valeted1139013va_leted
wakened1546873wa_kened
wasted104423023was__ted

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.403443402.0
2DLD Change Limit1461621437.97018339.0
3Display Results1431430.1101300.0
 (SQL Overall)1786911438.48321064.6
 
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.