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

188 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
careening1231001(None) 
careering12311201careering
caressing1238802caressing
carpeting1439482carpeting
cartoning12311112cartoning
caverning1536282caverning
coarsening1345542coarsening
cravening1547552cravening
creeling113513362c_reeling
creeping133310102c_reeping
darkening1535682darkening
gardening1236512gardening
greening103112532_greening
hardening1438022hardening
harkening1746922harkening
preening113115842_preening
screening1247182screening
adeeming1254793_adeeming
agreeing10295903agree_ing
aliening91510893_aliening
barbering14229683barbering
barning104320353bar__ning
barreling1238043barreling
bartending1444913bartending
bartering122313643bartering
battening12268853battening
brazening2185183brazening
breeding123411843_breeding
breezing20368133_breezing
burdening1335543burdening
cabining1338643ca_bining
cacheting1737153cacheting
cadencing1544963cadencing
cageling12310843ca_geling
calcining1447813calcining
cambering16109873cambering
cameoing1379063ca_meoing
canceling14310163canceling
caning94128623ca___ning
cankering162110793cankering
canning103620133ca__nning
cannoning1237323cannoning
canoeing11310213canoe_ing
cantering122417373cantering
cantoning12310883cantoning
canyoning1536873canyoning
capering132414963ca_pering
caravaning1644423caravaning
carding113922433car__ding
careen84119493caree__n_
careened1139193careen_ed
careener1039323careen_er
careeners1138533careeners
careens94514703caree__ns
careerism1345623careerism
careerist1148793careerist
caregiving1743143caregiving
caretaking1765333caretaking
caring95137993car___ing
carking144322853car__king
carling103727063car__ling
caroling113317003car_oling
carolling1259413carolling
caroming133312963car_oming
carousing1237893carousing
carpetings1544213carpetings
carping123521083car__ping
carroming1437683carroming
carrying14148373car_rying
carting104228283car__ting
cartooning1345883cartooning
carving133916773car__ving
caseating12311743caseating
casefying1843753casefying
casketing1635383casketing
catering112019903ca_tering
caveating1539293caveating
chartering16109253chartering
chastening1656523chastening
cheeking18349083c_heeking
cheeping16329553c_heeping
cheering143612703c_heering
cheesing14349413c_heesing
clarioning1345183clarioning
cleaning113112383c_leaning
cleeking15267813c_leeking
convening15311193convening
cooeeing1137453cooee_ing
corbeling1439033corbeling
cordoning1338063cordoning
cornering12311893cornering
corning103720123cor__ning
corseting12312173corseting
cozening20188303c_ozening
craning103620303c_r_aning
cratering12312653cratering
crayoning1535243crayoning
creaking153414123c_reaking
creaming133413143c_reaming
creasing113314443c_reasing
creating113921953c_reating
creeshing1536243c_reeshing
creneling1247733c_reneling
creping122913653c_r_eping
cresting114017043c_resting
crewing133212623c_r_ewing
crooning113112113c_rooning
crowning143510033c_rowning
curetting1236573curetting
curveting1535353curveting
dampening1535463dampening
darning93817333dar__ning
davening13258873da_vening
dreeing94311183_dree_ing
earning83418213ear__ning
farseeing1344383farseeing
fastening13268603fastening
fattening13287833fattening
freeing113713913_free_ing
freezing21308323_freezing
garmenting1445483garmenting
garnering11298083garnering
gartering112111573gartering
greeing93613783_gree_ing
greenings11266663_greenings
greenling1136753_greenling
greenwing1434693_greenwing
greeting103112353_greeting
happening1735593happening
hardenings1544243hardenings
harshening1744173harshening
hastening13259483hastening
havening15258553ha_vening
hearkening1844533hearkening
heartening1446733heartening
hoarsening1444403hoarsening
jargoning1845983jargoning
keening123713153__keening
ladening1078823la_dening
latening9711493la_tening
laveering1336813laveering
maddening1445113maddening
margenting1446153margenting
margining1337603margining
marketing1636513marketing
marooning1238593marooning
marveling1537103marveling
parceling1438443parceling
pardoning1338763pardoning
parenting12611583parenting
pargeting1338283pargeting
parleying1536113parleying
peening103318303__peening
preeing103817673_pree_ing
pureeing1137273puree_ing
queening1846113_queening
rarefying1654693rarefying
rattening10288763rattening
ravening122611293ra_vening
razeeing1834363razee_ing
reeding94124133__reeding
reefing114016863__reefing
reeking123318643__reeking
reeling83126863__reeling
reeving113717663__reeving
regreening1246033regreening
reining84425323__reining
saddening1245213saddening
sardining1137573sardining
scarpering1545413scarpering
screeding1336313screeding
screenings1343263screenings
sharpening1644883sharpening
sheening123010803_sheening
smartening1344993smartening
streeking14217453streeking
streeling10189483streeling
targeting1137303targeting
tautening1035843tautening
threeping15104803threeping
treeing83414303_tree_ing
unreeling1038983unreeling
unreeving1336213unreeving
wakening1636323wa_kening
warning113717093war__ning
weening114113973__weening
worsening1345553worsening
yarning113512953yar__ning

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.1561145455.1
2DLD Change Limit1486411887.40620070.3
3Display Results1881880.0762473.7
 (SQL Overall)1786911887.63823395.0
 
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.