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

197 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
caseating1231174(None) 
caveating1539291caveating
cascading1545672cascading
caseation1199512caseation
caseations1258302caseations
casefying1843752casefying
casketing1635382casketing
casting104628342cas__ting
castrating1349772castrating
catenating1348682catenating
cheating144014522c_heating
cleating113518132c_leating
creating113921952c_reating
miseating121215432miseating
nauseating1144982nauseating
reseating102421532reseating
seating84130682__seating
unseating10713202unseating
abating10413973_a_bating
abetting1158293_abetting
ablating11311993_ablating
absenting1236993absenting
accenting1487823accenting
accepting1695803accepting
acierating1348313acierating
actuating1239223actuating
acylating1547563acylating
aerating92821003_aerating
agenting1039383_agenting
alerting91312383_alerting
anearing9413973_anearing
asperating1349563_asperating
assaying1236003_assaying
assenting1038163assenting
asserting1038663asserting
astatine8313533_astatine
averting122512733_averting
aviating12311013_aviating
basseting1236153basseting
bassetting1344633bassetting
basting104227203bas__ting
beating104326873__beating
besetting12268423besetting
bisecting1436973bisecting
bleating113514503_bleating
cabbaging1744093cabbaging
cacheting1737153cacheting
cadencing1544963cadencing
cageling12310843cage_ling
cameoing1379063came_oing
canaling112016413ca_naling
canting104725903ca__nting
canulating1349543canulating
canvasing1546433canvasing
capering132414963cape_ring
careening12310013careening
careering12311203careering
caressing1238803caressing
caretaking1765333caretaking
carpeting1439483carpeting
carting104228283ca__rting
caseate9314783caseat__e
caseated11310713caseat_ed
caseates10313713caseat_es
casein83216453case__in_
caseins93115053case__ins
cashing135022553cas__hing
casing94829103cas___ing
casking144317353cas__king
cassation1197913cassation
cassations1276873cassations
castigating1546003castigating
castings113614053cas__tings
castling11311233cas_tling
casuarina1144973casuarina
catering112019903cate_ring
catfacing1744553catfacing
cathecting1844833cathecting
catting103922643ca__tting
causewaying2051003causewaying
cavatina1347333ca_vatina
cavatine13310323ca_vatine
caverning1536283caverning
cavitating1646903cavitating
cavorting1536063cavorting
ceasing104118263c__easing
cementing1438763cementing
chelating1549353chelating
cleaning113112383c_leaning
clearing113014883c_learing
cleaving141389683c_leaving
clefting14347583c_lefting
closeting1236183close_ting
coasting113615513coas__ting
coating103525313c__oating
cocreating15310293cocreating
coheading1636623coheading
coleading1338523coleading
collating12312763collating
combating16310163combating
consenting13313213consenting
corelating13511583corelating
corseting12312173corse_ting
cosseting1239543cosseting
costing104323023cos__ting
coveting141912303cove_ting
crating103725203c__rating
creaking153414123c_reaking
creaming133413143c_reaming
creasing113314443c_reasing
creatin93618133c_reatin_
creatine103417413c_reatine
creatins103617513c_reatins
cremating14312193cremating
cresting114017043c_resting
curating11314293c_urating
curetting1236573curetting
defeating142311973defeating
deserting11713143deserting
diseasing11310833diseasing
disrating11714553disrating
disseating121111783disseating
easting84924303eas__ting
eating75134403___eating
estating92614993_estating
exsecting1935933exsecting
exserting1736663exserting
faceting1438783face_ting
facetting1535283facetting
fasting114522833fas__ting
gasting95022763gas__ting
gazetting2043243gazetting
gestating11229983gestating
hasting114725193has__ting
heating114024323__heating
ideating10311703_ideating
inserting10914233inserting
insetting1079283insetting
instating10812213instating
lacerating1349443lacerating
lactating1239183lactating
lamenting1237693lamenting
lariating10311783lariating
lasting84725243las__ting
laureating1146393laureating
macerating1549533macerating
mandating1339773mandating
massaging1346353massaging
masting104325823mas__ting
misdating131010663misdating
mismating141211823mismating
misrating121014853misrating
misseating131310943misseating
narrating10310353narrating
outeating10814493outeating
palpating1438533palpating
parenting12611583parenting
passaging1345613passaging
pasting103826553pas__ting
patenting1248943patenting
pleating112916053_pleating
radiating111112123radiating
reheating132314913reheating
repeating122618983repeating
resealing102115673resealing
resecting122816483resecting
resenting102619293resenting
resetting102816293resetting
reslating102516993reslating
restating102319413restating
sashaying1644593sashaying
satiating10311803satiating
sating74735453__s_ating
sealing83528563__sealing
seaming103222113__seaming
searing83330923__searing
seatings93614303__seatings
sedating103014113__sedating
setting83621393__setting
skating123613853__skating
slating83724653__slating
stating83725163__stating
sweating123213023_sweating
tasting84624213tas__ting
threating131010053threating
treating92519613_treating
unsealing10711043unsealing
unseaming1278113unseaming
unsetting1088993unsetting
unstating10711213unstating
upsetting1275563upsetting
vacating14310353va_cating
valeting1238843vale_ting
valuating1338643valuating
variating13310943variating
wadsetting1542913wadsetting
wasting114422843was__ting

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 Limit1486411976.54622707.1
3Display Results1971970.0962052.1
 (SQL Overall)1786911977.06225303.2
 
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.