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

339 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
compend14401030(None) 
commend144010181commend
comped135919871compe_d
compends15378251compends
camped134720232campe_d
chomped17329772chompe_d
clomped14398972clompe_d
combed135516542combe_d
command14399212command
commends15308462commends
comment1310317702comment
company1619711142company
compeer133811552compeer
compel124412892compe_l
compels133210882compels
compendia1643952compendia
compere134616622compere
compered153414922compered
compete134716552compete
competed154113592competed
comping143518592comping
compone136517192compone
compony1613011912compony
compound1555992compound
compted143813522compted
contend103511892contend
cooped114821602coope_d
coped105036842co_pe_d
copen94826432co_pen_
copens106119962co_pens
copped135221252coppe_d
couped115019312coupe_d
impend11478782_impend
romped114513652rompe_d
amend85717753_am_end
amped104820513_ampe_d
append1138273_append
bombed134113873bombe_d
bookend14396643bookend
bopped134413403boppe_d
bumped134414003bumpe_d
camper124722213campe_r
campers134220283campers
camphene1746613camphene
camping143118973camping
campong14318123campong
caped104931803c_ape_d
capped134721853cappe_d
carped115923763carpe_d
cement103321663cem_ent
champed174111473champe_d
chomper163810073chompe_r
chompers17369573chompers
chomping18339883chomping
chopped174511003choppe_d
chumped17379493chumpe_d
clamped144012043clampe_d
cleped115114113clepe_d
clomping15329653clomping
clopped143611523cloppe_d
clumped143610663clumpe_d
clupeid1234633clupeid
coagent10313973coagent
coaled95022703coale_d
coapted123911493coapted
coated94927033coate_d
coattend1134643coattend
coaxed165612513coaxe_d
cocked155022563cocke_d
codded114515303codde_d
coded95433183co_de_d
coden86128543co_den_
codens94821013co_dens
coed77140543co__e_d
coempted1535333coempted
coextend1842483coextend
cofound1335513cofound
cogent9321003co_gent
cogged116416613cogge_d
cohead123811123co_head
coifed124113063coife_d
coigned11418663coigned
coiled95123933coile_d
coined94523603coine_d
coked124730693co_ke_d
colead94114643co_lead
coled85540753co_le_d
comae97128423comae__
combe116223543combe__
comber125118503combe_r
combers134516613combers
combes125321733combe_s
combine133014713combine
combined15269183combined
combing143714723combing
come87547703com_e__
comedo11359603com_edo
comedy14378233com_edy
comely134213733com_ely
comer95832693com_e_r
comers105328083com_ers
comes97246993com_e_s
comet95946073com_e_t
cometh134811683com_eth
comets105823583com_ets
coming114225453com_ing
commando15275753commando
commands15318813commands
commence16149103commence
commenced18157133commenced
commendam1544953commendam
commended17137013commended
commender16167923commender
commented16129603commented
comments142913873comments
common12310803common_
commons13311043commons
commune13329353commune
communed15338203communed
comp106731253comp___
compact153712213compact
companied1648023companied
compare135814993compare
compared153811823compared
compart134016003compart
compas125817063comp_as
compass13379563compass
compeered1646303compeered
compeers143410013compeers
compelled1646133compelled
compendium1953363compendium
comperes143217973comperes
compering163414163compering
competent15411253competent
competes144117243competes
competing163712463competing
compile13312443compile
compiled1537813compiled
compleat14710153compleat
complect1659013complect
complete143412053complete
completed162810263completed
complex2037243complex
complexed23295963complexed
complied1539673complied
complin13312073complin
compline14313553compline
complins14313103complins
complot13310683complot
comply152810383comp_ly
compo115318573comp__o
component15411083component
comport133616843comport
compos124818803comp_os
compose135716663compose
composed154612063composed
compost134515353compost
compote135616463compote
compounds1654503compounds
comprehend2073943comprehend
compress1439053compress
comps115526053comp__s
compt116328223comp__t
compting153013603compting
compts125216653comp_ts
compute134513653compute
computed154110943computed
comte96125473comte__
comtes106222813comte_s
concent114422513concent
coned86040053co_ne_d
congeed113212313congeed
conked135019113conke_d
conned95119703conne_d
consent93723113consent
contends112810573contends
content94326153content
convene123314323convene
convened143412223convened
convent123919413convent
cooed84534343co_oe_d
cooeed95917863co_oeed
cooked135921363cooke_d
cooled95224583coole_d
cooper104221123coope_r
coopered133310933coopered
coopers114019483coopers
coopery143910273coopery
cooping123918933cooping
coopted123710763coopted
cope86847383co_pe__
copeck1636943co_peck
copepod1444853co_pepod
coper95336093co_pe_r
copers104629843co_pers
copes97747103co_pe_s
copied114618563co_pied
coping113927663co_ping
copper124321893coppe_r
coppered153410543coppered
coppers133519753coppers
coppery16409393coppery
copping143918593copping
corded105923353corde_d
cored85044223co_re_d
corked135020783corke_d
corned95224523corne_d
coshed124217543coshe_d
cosied94819883cosie_d
costed95623113coste_d
coted85033853co_te_d
coupe96023483coupe__
coupes105022523coupe_s
couping124317023couping
coupled124312673coupled
coupon102810993coupon_
coupons112710553coupons
coved115027373co_ve_d
coven106925043co_ven_
covens114919263co_vens
cowbind1536613cowbind
cowed115637843co_we_d
cowhand1665933cowhand
cowherd1636953cowherd
cowled125218383cowle_d
cowmen13810923cowmen_
cowpea1337643cowpe_a
cowpeas1437273cowpeas
coxed154322813co_xe_d
coyed114623803co_ye_d
cozen165019703co_zen_
cozened19349183co_zened
cozens176314923co_zens
cozied184112153cozie_d
cramped144712183crampe_d
craped116120523crape_d
creped114115703crepe_d
crimped143910763crimpe_d
cropped143812063croppe_d
crumped144311223crumpe_d
cupped134413983cuppe_d
cusped114312043cuspe_d
cymene1377393cym_ene
damped124315583dampe_d
dampen114310593dampen_
dampened1435623dampened
dampens12348563dampens
depend103510923_depend
dispend11289413dispend
domed95423263dom_e_d
doped95326713do_pe_d
dumped123814493dumpe_d
emend86214893_em_end
expend16247503_expend
foment113718303fom_ent
fopped144012673foppe_d
forfend1435413forfend
gimped123911473gimpe_d
godsend1084043godsend
hempen1338963hempen_
holpen11299413holpen_
homed115425423hom_e_d
hooped125518183hoope_d
hoped115628183ho_pe_d
hopped144318113hoppe_d
humped144015243humpe_d
imped105117973_impe_d
impends12376803_impends
jumped183511553jumpe_d
lamped114017543lampe_d
limped114817123limpe_d
loment84021473lom_ent
looped95217173loope_d
loped85128333lo_pe_d
lopped114218623loppe_d
louped95316383loupe_d
loupen84510293loupen_
lumped114216963lumpe_d
lumpen104010663lumpen_
lumpens11298263lumpens
mend75334023__m_end
moment103319683mom_ent
moped105424733mo_pe_d
mopped134114323moppe_d
mumped133813163mumpe_d
nomen75621623nom_en_
offend13365663_offend
omen66828183_om_en_
omened93711003_om_ened
omens75618963_om_ens
oped76230153_o_pe_d
open66427003_o_pen_
opened94311863_o_pened
opens76118553_o_pens
pend75934533___pend
perpend12259333perpend
pimped134913483pimpe_d
pompano1345203pompano
pompon1238943pompon_
pompons1338553pompons
pooped113915943poope_d
popped104117813poppe_d
portend103411193portend
propend123311273propend
pumped133915563pumpe_d
ramped114617903rampe_d
recommend1664323recommend
remend95216553rem_end
romper104213683rompe_r
rompers113412243rompers
romping123113033romping
roped84630803ro_pe_d
rouped95717353roupe_d
scamped144711963scampe_d
scooped124611743scoope_d
scoped115116653sco_pe_d
soaped95817973soape_d
sopped114819903soppe_d
souped95017673soupe_d
spend85619333__spend
stipend10386553stipend
stomped124110533stompe_d
suspend1036013suspend
tamped114317043tampe_d
temped113912893tempe_d
tombed113812133tombe_d
tommed113310143tomme_d
toped85631313to_pe_d
topped114617723toppe_d
tromped124210293trompe_d
tumped114216233tumpe_d
umped104717273_umpe_d
upend85011043__upend
vamped144211013vampe_d
whomped18345473whompe_d
wimped144211513wimpe_d
womaned1337213womaned
wombed14419233wombe_d
women104619253wom_en_

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273397.84317088.7
3Display Results3393390.2331454.9
 (SQL Overall)1786913398.23221706.9
 
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.