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

271 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
caseated1131071(None) 
caseate9314781caseate_
caseates10313711caseates
casemated1446951casemated
caveated1439131caveated
cascaded14135702cascaded
casease939322casease_
caseases10410472caseases
casefied1445942casefied
casemate1239842casemate_
casemates1349522casemates
casette9310392casette_
casettes1039652casettes
casketed1534952casketed
castrated1239512castrated
catenated1238912catenated
caudated1238062caudated
cheated134416342c_heated
cleated103417842c_leated
created104323452c_reated
cuneated11310102cuneated
cuspated1335912cuspated
galeated104111572galeated
nauseated1045232nauseated
reseated93220262reseated
seated75131062__seated
unseated91317682unseated
abated95918453_a_bated
abetted1058323_abetted
ablated102513443_ablated
absented1156613absented
accented13107773accented
accepted15105383accepted
acerated113113983acerated
acetated112010683acetated
acierated1238283acierated
actuated1138743actuated
aculeated1247723aculeated
acylated1437873acylated
aerated85322373_aerated
afeared1176833_afeared
agented939423_agented
alated75625143_a_lated
alerted82512223_alerted
aneared8512743_aneared
ansated84214003_ansated
ascared10399523_ascared
ashamed1336243_ashamed
asperated1239313_asperated
assayed1135593_assayed
assented957513assented
asserted957903asserted
aurated83817793_aurated
averted112211613_averted
aviated11310263_aviated
baccated15148373baccated
basseted1136743basseted
bassetted1244693bassetted
basted95227233bas__ted
bisected1336203bisected
bleated104015973_bleated
cabbaged1644383cabbaged
cacheted16148233cacheted
cadenced1435523cadenced
caftaned1445093caftaned
calceate1239863calceate_
cameoed1238383came_oed
canaled103615563ca_naled
canted94825783ca__nted
canulated12310673canulated
canvased14246213canvased
capered123014043cape_red
capitated14159043capitated
capsulated1545653capsulated
carate84734003ca_rate_
carates95630613ca_rates
careened1139193careened
careered1139493careered
caressed1139163caressed
carinated123414263carinated
carpeted1338953carpeted
carted98631443ca__rted
caryatid1447953caryatid
cascabel14174503cascabel
cascade12118603cascade_
cascades13128553cascades
caseating12311743caseating
caseation1199513caseation
cased86032413cas___ed
casefies1339213casefies
caseinate1148243caseinate_
caseinates1247443caseinates
caseload1145623caseload
caseose939163caseose_
caseoses1039293caseoses
caserne93710063caserne_
casernes103810753casernes
cashed125124353cas__hed
casked134815513cas__ked
casqued19235633cas_qued
cassata938143cassat_a
cassatas1036683cassatas
cassette1047813cassette_
cassettes1146703cassettes
castanet10416193castanet
caste75932363cas__te_
castellated1443273castellated
caster85232573cas__ter
castes85631863cas__tes
castigated1446323castigated
castled104311513cas_tled
castrate10313863castrate_
castrater1148523castrater
castrates11312673castrates
catenate10312833catenate_
catenates11311813catenates
catered103117773cate_red
cathected1744543cathected
catted95422473ca__tted
caudate10311353caudate_
caudates11310263caudates
causewayed1951003causewayed
caveat11417723caveat__
caveator1387233caveator
caveats1239803caveat_s
caverned1436163caverned
cavitated15177353cavitated
cavorted1435693cavorted
cayenned1443163cayenned
ceased94920783c__eased
cemented1338373cemented
cerated103922473c_erated
cheater124816963c_heater
chelated142610483chelated
chested133811673c_hested
ciliated11510953ciliated
cisted95217523cis__ted
citrated112712253citrated
cleaned103512003c_leaned
cleared103612463c_leared
cleaved134010483c_leaved
clefted13326753c_lefted
closeted1135613close_ted
coasted104015953coas__ted
coated94927043c__oated
cocreated142710093cocreated
coheaded1536603coheaded
collated113615063collated
combated1539823combated
consented12311943consented
corelated12411823corelated
corseted11311473corse_ted
cosseted1178343cosseted
costate94019273costate_
costed95623113cos__ted
coveted133011523cove_ted
crabeater1345593crabeater
crated94827773c__rated
creaked143413233c_reaked
creamed123913713c_reamed
creased104315583c_reased
create85126383c_reate_
creates95225203c_reates
cremated133412963cremated
crenated113013913crenated
crested103416533c_rested
crispated1445023crispated
cristated1247423cristated
cuneate9311723cuneate_
curated104717583c_urated
curetted1137173curetted
cuspate1138233cuspate_
defeated132812163defeated
deserted101012203deserted
diseased103011713diseased
disrated10915573disrated
disseated11711083disseated
easeled8159853ease_led
estated83715573_estated
exsected1835673exsected
exserted1636213exserted
faceted13509563face_ted
facetted1445743facetted
falcated1438473falcated
fasciated1546133fasciated
fasted105320953fas__ted
foveated1536293foveated
galeate83916783galeate_
gasted84821583gas__ted
gazetted19234853gazetted
gestated102910573gestated
hastate10313913hastate_
hasted105125283has__ted
heated104525593__heated
ideated9310973_ideated
inserted92413053inserted
insetted9249023insetted
instated91613343instated
labiated11109303labiated
lacerated122210673lacerated
lactated1138863lactated
lamented1138193lamented
lanated8313203la_nated
lariated91212063lariated
lasted74323603las__ted
laureated1096153laureated
lineated9711063lineated
macerated142010523macerated
maleate94117543maleate_
maleates103316343maleates
mandated12310293mandated
massaged1236753massaged
masted94025803mas__ted
meated94222403__meated
misdated121211123misdated
miseaten10310773miseaten
mismated131111333mismated
misrated111315383misrated
misseated12610113misseated
narrated9310323narrated
nauseate845893nauseate_
nauseates946213nauseates
paleate94120003paleate_
palmated132511003palmated
palpated13249763palpated
parented11912213parented
passaged1236243passaged
pasted94426903pas__ted
patented1188893patented
pileated112711133pileated
pleated103816633_pleated
radiated102512593radiated
reheated122415003reheated
repeated113117443repeated
resealed92713963resealed
resected112514743resected
resented92716963resented
reslated93517523reslated
restated93120183restated
roseate7613453roseate_
sashayed1543553sashayed
sated66238533__s_ated
satiated9311603satiated
seabed95017693__seabed
sealed74328363__sealed
seamed94823883__seamed
seared75232843__seared
seater64534163__seater
sedated93714353__sedated
skated114414883__skated
slated75028313__slated
stated75427833__stated
sweated113411543_sweated
talented938423talented
tasted74123973tas__ted
teated74924023__teated
threated1259203threated
trabeated1246843trabeated
treated83618703_treated
unheated121514553unheated
unsated83419933uns_ated
unsealed91513623unsealed
unseamed111210663unseamed
unseared91113943unseared
unstated91615813unstated
vacated1349353va_cated
valeted1139013vale_ted
valuated12239203valuated
variated121211393variated
wadsetted1442623wadsetted
wasted104423023was__ted

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 Limit1461622716.78021557.8
3Display Results2712710.1102463.6
 (SQL Overall)1786912717.32624391.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.