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

394 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
compting15301360(None) 
coapting133511611coapting
coempting1636071coempting
competing163712461competing
comping143518591comp_ing
computing16309851computing
coopting133411311coopting
camping143118972camp_ing
chomping18339882chomp_ing
clomping15329652clomp_ing
coacting133412702coacting
coasting113615512coasting
coating103525312co_ating
comaking1739992comaking
combating16310162combating
combing143714732com_bing
coming114225452com__ing
commuting16288442commuting
compacting19177092compacting
comparing162410582comparing
comparting17188382comparting
compering163414162compering
compiling1637762compiling
completing1748422completing
complin13312072complin_
compline14313552compline
complins14313112complins
complying1936112complying
comporting17199162comporting
composing16179842composing
composting17178052composting
cooping123918932coop_ing
coping113927662co_p_ing
copping143918592co_pping
copying153411982co_pying
costing104323022co_sting
coting94629252co__ting
counting113115272counting
couping124317022coup_ing
coupling13310782coupling
courting112514572courting
coveting141912302coveting
opting94514402_o_pting
prompting1637202prompting
romping123113032romp_ing
tempting1357342tempting
vomiting1437732vomiting
accepting1695803accepting
adapting1236643adapting
adopting1237453adopting
amping114317573_amp_ing
boasting113512503boasting
boating103721303bo_ating
bolting104416763bo_lting
bombing143211393bom_bing
boosting113311053boosting
booting103821363bo_oting
bopping143512033bo_pping
borating113414503borating
bromating1439183bromating
bumping143812493bump_ing
cameoing1379063cameoing
campaign1544213campaign
camphine1738373camphine
campings154010203camp_ings
campong14318123camp_ong
campusing1654913campusing
canting104725903c_anting
capping143819673c_apping
carpeting1439483carpeting
carping123521083carp_ing
carting104228283c_arting
casting104628343c_asting
catting103922643c_atting
cementing1438763cementing
champing183610933champ_ing
chanting143413533chanting
chapping183710723chapping
charting142614193charting
chatting142810143chatting
cheating144014523cheating
chipping18389793chipping
chopping183710263chopping
chumping18349063chump_ing
chuting132910733c_huting
citing94220183c__iting
clamping154011153clamp_ing
clapping153810603clapping
cleating113518143cleating
clefting14347583clefting
cleping123310423clep_ing
clipping15349153clipping
clopping153511083clopping
closeting1236183closeting
clotting113110643clotting
clouting113011683clouting
clumping15319883clump_ing
coaching164011963coaching
coaling103722823co_aling
coaming123818323co_aming
coastings12357863coastings
coatings113811843co_atings
coaxing173511703co_axing
cobbling15248803cobbling
cocking163619983co_cking
cockling172310393cockling
codding124014693co_dding
coddling13258473coddling
coding104024793co__ding
codling114418953co_dling
coediting1338333coediting
coercing1349003coercing
coffing163811253co_ffing
coffling1736483coffling
cogging123513713co_gging
cohering142413833cohering
cohosting1546323cohosting
coiffing1755933coiffing
coifing133213893co_ifing
coigning1237173coigning
coiling103723453co_iling
coining103920543co_ining
coking134523883co__king
collating12312783collating
colleting12311063colleting
collying14319553collying
coloring11414843coloring
comatic131816943comati_c
comatik15139723comati_k
comatiks16148043comatiks
combatting1755143combatting
combine133014723com_bine
combings15348323com_bings
combining1637893combining
combusting1745453combusting
cometic131215723cometi_c
comforting18165933comforting
comings124013533com__ings
comitia1139723comiti_a
comitial1248693comitial
comities12317793comities
commenting1749173commenting
committing1746683committing
commixing2345193commixing
commoving1944983commoving
communing16207863communing
company1619711143comp_any
companying2044813companying
compassing1746553compassing
compeering1747053compeering
compelling1746553compelling
compend144010303comp_end
competent15411253competent
compile13312443comp_ile
complain1448763complain_
complains1549193complains
complaint15410253complaint
complecting2045763complecting
complexing2444743complexing
compliant1549663compliant
complice1639333complice
complied1539673complied
complier14310253complier
complies14314523complies
complines15312833complines
complotting18124263complotting
compone136517193comp_one
compony1613011913comp_ony
compositing1846263compositing
compound1555993compound
comprise14310813comprise
comprising1748633comprising
comprize2368733comprize
comprizing2647463comprizing
compt116328223compt___
compted143813523compt_ed
compts125216653compt__s
computist1547323computist
confuting1539093confuting
congaing1239823congaing
coning94331823co__ning
conking143618453co_nking
conning103718753co_nning
connoting12310023connoting
cooeeing1137453cooeeing
cooeying1438143cooeying
cooing94024923co__oing
cooking143818973co_oking
cooling103422573co_oling
coopering142611323coopering
cooption1288343cooption
cooptions13107763cooptions
copings124111843co_p_ings
coppering162810893coppering
coppicing1845403coppicing
cording113620823co_rding
coring94433963co__ring
corking143018823co_rking
corning103720123co_rning
corrupting1555583corrupting
corseting12312173corseting
cortin82423153co_rtin_
cortina91915973co_rtina
cortins92421333co_rtins
coshing134316433co_shing
cosseting1239543cosseting
cosying134513133co_sying
cotinga10348023co__tinga
couching163213263couching
coughing15309213coughing
couplings1435543couplings
couponing1446293couponing
coursing113112023coursing
covering142215723covering
coving124321523co__ving
cowering142514033cowering
cowing124526323co__wing
cowling134017423co_wling
cowriting1557323cowriting
coxing164218863co__xing
coying124021483co__ying
cozening20188303cozening
cozying22308063co_zying
crafting143710173crafting
cramping153411853cramp_ing
craping124018713crap_ing
crapping153911453crapping
crating103725203c_rating
creating113921953creating
cremating14312203cremating
creping122913653crep_ing
cresting114017043cresting
crimping15299783crimp_ing
crimpling1645343crimpling
cropping153210883cropping
crumping15319903crump_ing
crumpling1645323crumpling
crusting113612793crusting
cupping144312383c_upping
curating11314293curating
cutting103817493c_utting
cymbling1834773cymbling
cymling1536273cym_ling
damping133414003damp_ing
demoting12311423demoting
dimpling14199023dimpling
doating93816863do_ating
doming104218393dom__ing
donating10311803donating
doping103919463do_p_ing
doting84821913do__ting
dotting93314483do_tting
doubting1237373doubting
dumping133712913dump_ing
dumpling14217893dumpling
emoting10313563_emoting
emptings1364823_emptings
emptins1179403_emptins
emptying1634243_emptying
erupting11218443erupting
exempting2144223exempting
foisting122910503foisting
fomenting1537233fomenting
footing115017593fo_oting
fopping153511133fo_pping
gimping133710763gimp_ing
hoisting123610903hoisting
homaging1536613homaging
homering141512073homering
homing123718383hom__ing
hooping133615703hoop_ing
hooting113919883ho_oting
hoping123719743ho_p_ing
hopping154115273ho_pping
hoppling16206763hoppling
hosting114318383ho_sting
hotting113116523ho_tting
humphing1935163humphing
humping153213073hump_ing
imping114315353_imp_ing
imputing1336853_imputing
iodating1038823iodating
jointing16248613jointing
joisting16328503joisting
jolting153410913jo_lting
jotting152912773jo_tting
jousting16309353jousting
jumping19319803jump_ing
lamping123116003lamp_ing
limiting1138813limiting
limping124614113limp_ing
locating11311503locating
locomoting1543503locomoting
lofting113311313lo_fting
looping103615283loop_ing
looting83019643lo_oting
loping93921413lo_p_ing
lopping123815223lo_pping
lotting82917753lo_tting
louping104313983loup_ing
louting83719383lo_uting
lumping123314643lump_ing
mating94832913__mating
meting94320593__meting
moating104218153mo_ating
molting103517173mo_lting
mooting103019363mo_oting
moping114017103mo_p_ing
mopping143411473mo_pping
morphing1637553morphing
moulting112710313moulting
mounting112711813mounting
mumping143411633mump_ing
muting93921523__muting
notating92513343notating
noting74120153no__ting
omening10310093_omening
omitting11217743_omitting
oompahing1773173oompahing
oping86322413_o_p_ing
orating83520323_orating
ousting84021353_ousting
outing74128153_o_uting
pimping143812123pimp_ing
pointing112813683pointing
pomading1437423pomading
pooping123615443poop_ing
popping113715413po_pping
poppling12227323poppling
porting103021783po_rting
positing11312303positing
posting105622243po_sting
potting103720893po_tting
pouting103519943po_uting
promoting1439923promoting
pumping144213553pump_ing
ramping123316873ramp_ing
recomputing1844343recomputing
remating112322423remating
rimpling13219663rimpling
roasting93012703roasting
roosting93411463roosting
rooting83522433ro_oting
roping94023023ro_p_ing
rotating92614553rotating
rotting82919683ro_tting
rouping103715793roup_ing
rousting93913273rousting
routing83821093ro_uting
rumpling13178763rumpling
sampling13510643sampling
scamping153510193scamp_ing
scooping133610633scoop_ing
scooting113012643sco_oting
scoping123513823sco_p_ing
scouting112612753sco_uting
scripting1437473scripting
sculpting1435003sculpting
smiting103014443_smiting
soaping103616223soap_ing
solating9315593solating
something1545403something
sooting82820963so_oting
sopiting11310763sopiting
sopping123917203so_pping
sorting83221813so_rting
souping104215533soup_ing
stomping13309763stomp_ing
tamping122815813tamp_ing
temping122710693temp_ing
toasting93410583toasting
toiting83217093to_iting
tombing123310533tom_bing
tomming12359243tom_ming
tooting83019423to_oting
toping94122993to_p_ing
topping123514623to_pping
toppling13197353toppling
toting74123793to__ting
totting82816843to_tting
touting84118453to_uting
tromping13319603tromp_ing
tumping123114243tump_ing
umping114815333_ump_ing
vamping152810233vamp_ing
voting103916033vo__ting
whomping19285943whomp_ing
wimping153911013wimp_ing
wimpling16207483wimpling
womaning1437643womaning
wonting113214103wo_nting
woopsing1435633woopsing
worsting1267683worsting
wotting112913843wo_tting

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.406440125.6
2DLD Change Limit1461623947.76618820.8
3Display Results3943940.1702317.6
 (SQL Overall)1786913948.34221420.6
 
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.