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

148 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
caressing123880(None) 
accessing1445832accessing
careening12310012careening
careering12311202careering
caressingly1752952caressingly
caressive1445822caressive
carousing1237892carousing
cessing103814812c__essing
creasing113314442c_reasing
cresting114017042c_resting
crossing112612682c_rossing
dressing102810422_dressing
egressing1146852egressing
harassing1346982harassing
harnessing1443902harnessing
pressing112516442_pressing
stressing1038332stressing
addressing1343133addressing
aggressing1344183aggressing
amassing1138003_amassing
arising83619973_ar_ising
arousing93811803_arousing
arresting1038633arresting
assessing1045173assessing
blessing1137593_blessing
brassing112612303_brassing
cadencing1544963cadencing
cageling12310843cage_ling
callusing1236173callusing
cameoing1379063came_oing
campusing1654913campusing
canvasing1546433canvasing
canvassing1643803canvassing
capering132414963cape_ring
capeskin1644403capeskin_
capeskins1744073capeskins
carding113922433car__ding
caregiving1743143caregiving
caress85720263caress___
caressed1139163caress_ed
caresser1038803caress_er
caressers1137433caressers
caresses10314063caress_es
caretaking1765333caretaking
caring95137993car___ing
carking144322853car__king
carling103727063car__ling
caroling113317003car_oling
carolling1259413carolling
caroming133312963car_oming
carpeting1439483carpeting
carping123521083car__ping
carroming1437683carroming
carrying14148373car_rying
cartelising1444793cartelising
carting104228283car__ting
cartoning12311113cartoning
carving133916773car__ving
caseating12311743caseating
casefying1843753casefying
cashing135022553ca__shing
casing94829103ca___sing
casking144317353ca__sking
cassina94113163ca__ssina
cassine93817283ca__ssine
cassino93512433ca__ssino
casting104628343ca__sting
catering112019903cate_ring
caucusing1443803caucusing
caucussing1542583caucussing
causing103614413ca__using
caveating1539293caveating
caverning1536283caverning
ceasing104118263c__easing
censing104215263c__ensing
cheesing14349413c_heesing
chorussing16193323chorussing
classing113211793c_lassing
coalescing1545163coalescing
coarsening1345543coarsening
compressing1846433compressing
confessing1647183confessing
congressing1545603congressing
corseting12312173corseting
crashing143512633c_rashing
creaking153414123c_reaking
creaming133413143c_reaming
creating113921953c_reating
creeling113513363c_reeling
creeping133310103c_reeping
creeshing1536243creeshing
creping122913653c_re_ping
crestings12298043c_restings
crevassing1643533c_revassing
crewing133212623c_re_wing
crisping13319663c_risping
crossings12217163c_rossings
cruising112610153c_ruising
crushing143010053c_rushing
crusting113612793c_rusting
cuirassing1343023cuirassing
curetting1236573curetting
cursing104217033cur__sing
curtsying1543813curtsying
cussing103814273c__ussing
depressing1448093depressing
digressing1345793digressing
dressings11265373_dressings
excessing1945713excessing
expressing2046623expressing
farseeing1344383farseeing
fessing113812863__fessing
finessing1345123finessing
foresting13311363foresting
freshing152611023_freshing
gassing94216333ga__ssing
grassing103311973_grassing
greasing102811393_greasing
grossing103111063_grossing
guessing1036243_guessing
harvesting1744413harvesting
impressing1547543impressing
jessing153710623__jessing
massing104318023ma__ssing
messing103916393__messing
obsessing1244263obsessing
oppressing1545973oppressing
parenting12611583parenting
parsing103819553par__sing
passing104318423pa__ssing
pressings12269023_pressings
prissing113011453_prissing
rarefying1654693rarefying
recessing12611013recessing
redressing1247823redressing
regressing1248143regressing
repressing13310393repressing
resting85031183__resting
reusing82516783__reusing
sassing84615553sa__ssing
threshing1645663threshing
trussing9268653_trussing
undressing1246533undressing
unresting10311133unresting
waitressing1552493waitressing
warsling12198593war_sling
wresting123811833_wresting
yessing113210063__yessing

Search took 10 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.423422437.4
2DLD Change Limit1486411488.76616956.5
3Display Results1481480.1401057.1
 (SQL Overall)1786911489.32919154.4
 
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.