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

185 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
compared15381182(None) 
compare135814991compare_
comparer143611361comparer
compares143816431compares
comparted16338421comparted
compered153414921compered
collared113211142collared
combated1539822combated
compacted18297362compacted
compadre15295882compadre_
compadres16266412compadres
companied1648022companied
comparers15319392comparers
compart134016002compar_t
comparts144210832comparts
compassed1645542compassed
comped135919872comp__ed
compeered1646302compeered
compere134616622compere_
comperes143217972comperes
competed154113592competed
compiled1537812compiled
complied1539672complied
comported16319532comported
composed154612062composed
compted143813522comp_ted
computed154110952computed
coopered133310932coopered
coppered153410542coppered
oompahed1642902oompahed
bombard1437333bombar_d
bombarded17123633bombarded
bumpered1536003bumpered
cambered15129003cambered
camped134720233camp__ed
camporee1449343camporee
campused1535253campused
capered123014043c_apered
cared86050093c___ared
cellared11398793cellared
chared125423693c__hared
chomped17329773chomp__ed
choppered1964883choppered
cleared103612463c_leared
clomped14398973clomp__ed
coaled95022703co__aled
coappeared1742273coappeared
coapted123911503coap_ted
coated94927043co__ated
coaxed165612513co__axed
cochaired1743883cochaired
cockaded1836393cockaded
cockered17710213cockered
coempted1535333coemp_ted
coffered1737673coffered
coheaded1536603coheaded
cohered133514693co_hered
collaged12279963collaged
collard103712923collar_d
collaret103116703collaret
collated113615063collated
colored10313473co_lored
coloured1148313coloured
comade114415323com_ade_
comae97128423com_a_e_
comake144413423com_ake_
comaker153410603com_aker
comakes154413643com_akes
comanaged1544523comanaged
comate104124843com_ate_
comates114123643com_ates
combater1439383combater
combatted1644653combatted
combed135516543com__bed
combined15269183combined
comforted17315963comforted
comfrey1734683com_frey
command14399213comma_nd
commanded17136503commanded
commerced18125463commerced
commixed2264743commixed
commoved1844763commoved
communed15338213communed
commuted15288983commuted
compact153712213compa_ct
compacter17257883compacter
compacts16368903compacts
companies15311803companies
company1619711143compa_ny
comparing162410583comparing
compas125817063compa__s
compass13379563compa_ss
compasses1547393compasses
compeer133811553comp_eer
compeers143410013compeers
compel124412893comp__el
compelled1646133compelled
compend144010303comp_end
compete134716553compete_
competes144117243competes
compile13312443compile_
compiler1438373compiler
compiles14311983compiles
complained17175793complained
completed162810263completed
complex2037243comp_lex
complexed23295973complexed
complier14310253complier
complies14314523complies
compone136517193compone_
comport133616843compor_t
comports143411983comports
compose135716663compose_
composer145012953composer
composes145017113composes
composted16378813composted
compote135616463compote_
compotes144716513compotes
compound1555993compound
compress1439053comp_ress
comprised1648053comprised
comprized2567223comprized
compute134513663compute_
computer144511513computer
computes143914553computes
comrade12139213comrade_
comrades13149773comrades
concaved1636223concaved
congaed11399743conga_ed
conjured18117903conjured
conspired1445663conspired
cooped114821603coop__ed
coopted123710763coop_ted
coparent12412253co_parent
coped105036843co_p__ed
copied114618563co_p_ied
copped135221253co_p_ped
coppiced1734823coppiced
copyread1643783co_pyread
cored85044223co___red
cornered11311133cornered
corraded12128293corraded
coshered14610293coshered
costard104113353costar_d
costarred1244703costarred
cottered112511733cottered
couped115019313coup__ed
coupled124312673coup_led
covaried1448003co_varied
covered133315293co_vered
coward12411673co_war_d
cowered133214643co_wered
cumbered15157963cumbered
cuspated1335913cuspated
dogeared1145793dogeared
empaled12288953_empaled
hampered16239933hampered
homaged1497413hom_aged
homebred16215893homebred
homered133212713hom_ered
impaired1335143_impaired
impaled12288513_impaled
imparked17264863_imparked
imparted13248063_imparted
loppered13326753loppered
mortared1137213mortared
oared65030653_o__ared
pampered15229223pampered
pared86946763___pared
pomaded13377863pom_aded
prepared132210863prepared
rampaged1434103rampaged
ramparted1443543ramparted
roared75015393ro__ared
romped114513653romp__ed
scampered1635233scampered
schmeared1743053schmeared
simpered1338253simpered
smeared104510623_smeared
soared74324293so__ared
spared95427493__spared
tampered13279463tampered
tempered13248213tempered
umpired1235783_umpired
womaned1337213wom_aned

Search took 7 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.1561145455.1
2DLD Change Limit1461621856.64022012.3
3Display Results1851850.0762434.2
 (SQL Overall)1786911856.87226002.8
 
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.