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

164 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
compends1537825(None) 
commends15308461commends
compend144010301compend_
commands15318822commands
commend144010182commend_
comments142913882comments
comped135919872compe_d_
compeers143410012compeers
compels133210882compe_ls
compendia1643952compendia
comperes143217972comperes
competes144117242competes
compounds1654502compounds
contends112810572contends
copens106119962co_pen_s
impends12376802_impends
amends94713283_am_ends
appends1236393_appends
bookends15374853bookends
calends1039523c_alends
camped134720233campe_d_
campers134220293campe_rs
camphenes1846463camphenes
campings154010203campings
campongs15356123campongs
cements112714223cem_ents
chomped17329773chompe_d_
chompers17369593chompe_rs
clomped14398973clompe_d_
clupeids1343243clupeids
coagents1138453coagents
coattends1243913coattends
codens94821013co_den_s
coeds85920163co__e_ds
coextends1942323coextends
cofounds1444713cofounds
coheads13289233co_heads
coleads102911423co_leads
combed135516543combe_d_
combers134516623combe_rs
combes125321733combe__s
combineds16255283combineds
combines142814623combines
combings15348323combings
comedo11359603com_e_do
comedos12329073com_edos
comedy14378233com_e_dy
comers105328083com_e_rs
comes97246993com_e__s
comets105823583com_e_ts
comings124013533com_ings
command14399213command_
commando15275753commando
commandos16245963commandos
commence16149103commence
commences17139583commences
commendam1544953commendam
commendams1644303commendams
commended17137013commended
commender16167923commender
commenders17137143commenders
comment1310317703commen_t
commons13311043common_s
communes143411243communes
compacts16368903compacts
companies15311803companies
company1619711143compan_y
compares143816433compares
comparts144210833comparts
compas125817063comp__as
compass13379563comp_ass
compeer133811553compe_er
compel124412893compe__l
compendious1853373compendious
compendium1953363compendium
compendiums2052173compendiums
compere134616623compe_re
compered153414923compered
compete134716553compe_te
competed154113593competed
compiles14311983compiles
comping143518593compin_g
complects1766413complects
completes153212923completes
complexes22308103complexes
complies14314523complies
complines15312833complines
complins14313113complins
complots1438163complots
compone136517193compon_e
components1646943components
compony1613011913compon_y
comports143411983comports
compos124818803comp__os
composes145017113composes
composts144210913composts
compotes144716513compotes
compound1555993compound_
comprehends21103213comprehends
compress1439053compress
comps115526053comp___s
compted143813523compted_
compts125216653comp__ts
computes143914553computes
comtes106222813comte__s
concents122516603concents
consents102715893consents
contend103511893contend_
contents104018213contents
convenes132916913convenes
convents132614603convents
cooped114821603coope_d_
coopers114019483coope_rs
copecks1745873co_pecks
coped105036843co_pe_d_
copen94826433co_pen__
copepods1544713co_pepods
copers104629843co_pe_rs
copes97747103co_pe__s
copings124111843co_pings
copped135221253coppe_d_
copperas14308573copperas
coppers133519753coppe_rs
couped115019313coupe_d_
coupes105022523coupe__s
coupons112710563coupon_s
covens114919263co_ven_s
cowbinds1634453cowbinds
cowhands1765263cowhands
cowherds1735423cowherds
cowpeas1437273cowpe_as
cozens176314923co_zen_s
cymenes1477413cym_enes
dampens12348563dampen_s
depends11348993_depends
dispends12308533dispends
emends95711433_em_ends
expends17217083_expends
foments122912053fom_ents
forfends1544833forfends
godsends11113353godsends
impend11478793_impend_
loments93413473lom_ents
lumpens11298263lumpen_s
mends84927693__m_ends
moments113113123mom_ents
mopeds11499663mo_pe_ds
offends14234293_offends
omens75618963_om_en_s
opens76118553_o_pen_s
pends85527193___pends
perpends13227753perpends
pompanos1445243pompanos
pompons1338553pompon_s
portends11358963portends
propends13249173propends
recommends1763163recommends
remends105013033rem_ends
romped114513653rompe_d_
rompers113412243rompe_rs
spends94714473__spends
stipends11304793stipends
suspends1145143suspends
upends9438763__upends

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 Filter1786911461620.403443402.0
2DLD Change Limit1461621646.92321112.5
3Display Results1641640.0632603.2
 (SQL Overall)1786911647.38924183.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.