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

446 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
cheering14361270(None) 
cheeking18349081cheeking
cheeping16329551cheeping
cheesing14349411cheesing
sheering123715101sheering
capering132414962capering
careering12311202careering
catering112019902catering
cering94522532c__ering
chairing143110772chairing
charing133721322ch_aring
charring142913162charring
cheating144014522cheating
checkering2244402checkering
checking20379202checking
cheerier1348002cheerier
cheerily1655422cheerily
cheerio12379312cheeri_o
cheerios13317572cheerios
cheffing2034462cheffing
chefing16359032ch_efing
chequering2543122chequering
chevying2034052chevying
chewing163911142ch_ewing
chirring142610172chirring
choiring14279782choiring
choring133617662ch_oring
churring14298652churring
clearing113014882clearing
cleeking15267812cleeking
cohering142413832cohering
covering142215722covering
cowering142514032cowering
creeling113513362creeling
creeping133310102creeping
fleering123811282fleering
hearing113324162_hearing
heeding123515062_heeding
heeling113618512_heeling
heezing20349872_heezing
heiring113312902_heiring
herring113615872_herring
jeering153513042_jeering
leering83417642_leering
ochering14219392och_ering
peering103520352_peering
queering1838202queering
schmeering1843432schmeering
shearing123915902shearing
sheening123010802sheening
sheeting122712822sheeting
sneering93414502sneering
speering113116322speering
steering93916792steering
veering113213682_veering
wheeling15318592wheeling
wheeping17337102wheeping
wheezing24315382wheezing
achieving1843303achieving
adeeming1254793adeeming
adhering1338873adhering
altering91917113altering
anearing9413973anearing
angering102113803angering
ashlering1344153ashlering
averring12239063averring
bearing103624773_bearing
beefing133911473_beefing
beeping124013913_beeping
blearing113111943blearing
bleeding12359053bleeding
bleeping13377933bleeping
bowering142911713bowering
breeding123411843breeding
breezing20368133breezing
cageling12310843cageling
cambering16109863cambering
cameoing1379063cameoing
cankering162110793cankering
cantering122417373cantering
careening12310013careening
caring95137993c__aring
cashiering1643783cashiering
caverning1536283caverning
ceasing104118263c_easing
ceding104014803c__eding
ceiling103416723c_eiling
celling103921263c_elling
censing104215263c_ensing
centering122915143centering
centring112112953centring
cessing103814813c_essing
chaffering22104633chaffering
chaffing2036323chaffing
chafing163911493ch_afing
chagrin1337883chagrin_
chagrins1437063chagrins
chaining142810783chaining
chalking183310063chalking
chambering20116033chambering
chamfering21125323chamfering
champing183610933champing
chancing162810283chancing
changing153211513changing
chanting143413533chanting
chapping183710723chapping
chaptering18107953chaptering
charging152910773charging
charking183512613charking
charming163012023charming
chartering16109243chartering
charting142614193charting
chasing133715893ch_asing
chattering16108633chattering
chatting142810143chatting
chawing164813033ch_awing
cheapening1883803cheapening
cheekier1735103cheekier
cheekily2053473cheekily
cheer105420383cheer___
cheered133713293cheer_ed
cheerer123511753cheer_er
cheerers13319543cheerers
cheerful1643983cheerful
cheeriest1438213cheeriest
cheeriness1545533cheeriness
cheerled14105703cheerled
cheerly15417603cheer_ly
cheero114712933cheer__o
cheeros123711633cheer_os
cheers114518913cheer__s
cheery144913153cheer__y
cheesier1335963cheesier
cheesily1654413cheesily
chelating1549353chelating
cherish15310463ch_erish
cherries131812973cherries
cheveron1645263cheveron_
cheverons1745203cheverons
chevron1575783chevron_
chevrons1665463chevrons
chewink19315113ch_ewink
chiding143911593ch_iding
childing15288503childing
chilling143512183chilling
chiming153311833ch_iming
chining133316843ch_ining
chinking183210893chinking
chinning14329653chinning
chippering2045163chippering
chipping18389793chipping
chirking18339383chirking
chirming16318643chirming
chirping16278863chirping
chiseling1536403chiseling
chitling142910663chitling
chittering16107183chittering
chivying2034973chivying
chlorin123112993chlorin_
chlorine133013303chlorine
chlorins132612883chlorins
chocking204011013chocking
choking173911943ch_oking
chomping18339883chomping
choosing142010133choosing
choppering2064813choppering
chopping183710263chopping
chording15410153chording
chorine123218363ch_orine
chousing14259423chousing
chowdering2044163chowdering
chowing164412773ch_owing
chowsing17217343chowsing
chroming163410723chroming
chucking20379503chucking
chuffing2055043chuffing
chugging1634913chugging
chumming18366203chumming
chumping18349063chumping
chunking18328053chunking
chuntering1647803chuntering
churning14237173churning
chuting132910733ch_uting
cindering13311213cindering
cinerin9313823cinerin_
cinerins10414093cinerins
ciphering17217693ciphering
clavering1538373clavering
cleaning113112383cleaning
clearings12286063clearings
clearwing1533673clearwing
cleating113518133cleating
cleaving141389683cleaving
clefting14347583clefting
cleping123310423c_leping
clerking15257163clerking
clewing13359583c_lewing
clouring112811273clouring
clueing104110093clue_ing
cockering1839693cockering
coercing1349003coercing
coexerting2045493coexerting
coffering1838043coffering
coheading1636623coheading
coloring11414843coloring
compeering1747053compeering
compering163414163compering
cooeeing1137453cooeeing
cooeying1438143cooeying
coopering142611323coopering
coppering162810893coppering
coring94433963c__oring
cornering12311893cornering
coshering15510023coshering
coverings15217883coverings
coveting141912303coveting
cozening20188293cozening
cratering12312653cratering
creaking153414113creaking
creaming133413143creaming
creasing113314443creasing
creating113921953creating
creeshing1536243creeshing
creneling1247733creneling
creping122913653c_reping
cresting114017043cresting
crewing133212623c_rewing
cueing94913613c_ue_ing
cumbering16108193cumbering
cupeling1338863cupeling
curing94824783c__uring
curring103616843c_urring
cyphering20175243cyphering
deeding103315123_deeding
deeming113913123_deeming
dowering132510613dowering
dreeing94311183dree_ing
earing75235483__earing
entering91920053entering
erring73816473__erring
fearing113520033_fearing
feeding123515073_feeding
feeing104416503_fee_ing
feeling113617073_feeling
feezing204610163_feezing
fevering152510083fevering
fleecing14347573fleecing
fleeing113511293flee_ing
fleeting122910323fleeting
freeing113713913free_ing
freezing21308323freezing
gearing92818843_gearing
geeing84313763_gee_ing
gleeking14316493gleeking
gleeting10279173gleeting
greeing93613783gree_ing
greening103112533greening
greeting103112353greeting
haeing104118923_hae_ing
haring104233003_h_aring
havering152211053havering
heading122919113_heading
healing113922963_healing
heaping133015853_heaping
hearings123611843_hearings
hearsing1239383_hearsing
hearting12513123_hearting
heating114024323_heating
heaving144114763_heaving
hedging13348953_hedging
heelings12359753_heelings
hefting144510913_hefting
heiling113616363_heiling
helling114623223_helling
helming133712003_helming
helping133512223_helping
helving144011133_helving
hemming15269973_hemming
henting113719653_henting
herding122915123_herding
herein93717793_herein_
herrings12379523_herrings
herrying15147013_herrying
hewing134514243_h_ewing
hexing174210513_h_exing
hieing104216623_hie_ing
hiring104421603_h_iring
hoeing104117023_hoe_ing
homering141512073homering
hovering151911143hovering
inhering12913703inhering
jeeing144512143_jee_ing
jeeping174010333_jeeping
keeking114210893_keeking
keeling123515123_keeling
keening123713153_keening
keeping144012543_keeping
kneeing12226523knee_ing
kneeling13287783kneeling
lagering102212313lagering
laveering1336813laveering
layering122310353layering
lechering1538443lech_ering
levering122212503levering
livering122012373livering
lowering122210913lowering
meeting103314963_meeting
metering112915633metering
metring103215283_metring
mitering113015393mitering
nearing83020333_nearing
needing93214423_needing
nidering10510473nidering
ochring13156673och__ring
offering1536393offering
ordering1039343ordering
overing111918053_overing
papering132213313papering
peeing94618083_pee_ing
peeking144414953_peeking
peeling102919873_peeling
peening103318303_peening
peeping123615213_peeping
peeving135112243_peeving
petering112516813petering
pickeering1943533pickeering
powering142210803powering
preeing103817673pree_ing
preening113115843preening
queening1846113queening
rearing83128783_rearing
reeding94124133_reeding
reefing114016863_reefing
reeking123318643_reeking
reeling83126863_reeling
reeving113717663_reeving
rehearing132211763rehearing
reheeling13218263reheeling
rehiring122911883rehiring
revering122918073revering
rogering10310273rogering
sabering112113743sabering
scheming1636633sch_eming
schmearing1842863schmearing
screeding1336313screeding
screening1247183screening
searing83330923_searing
seeding93719483_seeding
seeing74222143_see_ing
seeking124016063_seeking
seeling83522003_seeling
seeming103216263_seeming
seeping103817913_seeping
sering74731813__sering
severing122013853severing
sewering122411093sewering
sharing113723243sh_aring
sheafing15329483sheafing
shealing123415463shealing
shearings13337563shearings
shearling1336923shearling
sheaving154110253sheaving
shedding14278113shedding
sheetings13256713sheetings
shelling123515213shelling
sheltering1446493sheltering
shelving15278173shelving
shending132511253shending
shewing143812193sh_ewing
shieling123512403shieling
shirring122910443shirring
shivering1637333shivering
shoeing113211873shoe_ing
shoring112820063sh_oring
showering1646403showering
showring1548313showring
shrewing15228083shrewing
skeeing12308853skee_ing
skewering1744633skewering
sleeking133410963sleeking
sleeping113812053sleeping
sleeting93114163sleeting
sleeving12359283sleeving
smearing113511753smearing
smeeking15317833smeeking
sneezing18267053sneezing
sobering111912783sobering
spearing113216103spearing
speeding122810933speeding
speeling112713123speeling
speerings12276833speerings
speiring113711263speiring
sphering142811943sphering
spiering112713353spiering
steeking133411353steeking
steeling93615143steeling
steeping113412583steeping
steeving12359653steeving
supering11317683supering
swearing123711443swearing
sweeping14389143sweeping
sweeting123911313sweeting
tabering112211423tabering
tapering112112503tapering
tearing84021493_tearing
teeing73916973_tee_ing
teeming103513093_teeming
teetering10239893teetering
theelin1038003theelin_
theelins1137643theelins
theming133610473th_eming
therein102310353therein_
thieving1535143thieving
threeping15104803threeping
tiering8315243_tiering
tochering1537153toch_ering
towering122610873towering
treeing83414303tree_ing
tweeting12267033tweeting
tweezing21384113tweezing
ulcering1139333ulcering
umbering1399433umbering
unerring9311273unerring
unheeding1446103unheeding
ushering1258923ushering
uttering91613083uttering
veneering1337663veneering
wafering15208893wafering
wagering13219523wagering
watering122316313watering
wavering152410543wavering
wearing113318863_wearing
weeding123815213_weeding
weening114113973_weening
weeping133613673_weeping
weeting113816053_weeting
wheedling1733073wheedling
wheelings16284933wheelings
wheepling1843323wheepling
whelming17304923whelming
whelping17245333whelping
wherein13216593wherein_
wherrying1952983wherrying
whetting1535973whetting
whirring15286283whirring
whoring142910293wh_oring

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.1731032896.0
2DLD Change Limit1461624467.97018339.0
3Display Results4464460.1862397.8
 (SQL Overall)1786914468.32921454.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.