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

198 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
compart13401600(None) 
compact153712211compact
compare135814991compare
comparts144210831comparts
comport133616841comport
combat12316752comba_t
comfort143611692comfort
compacts16368902compacts
compadre15295882compadre
company1619711142company
compared153811822compared
comparer143611362comparer
compares143816432compares
comparted16338422comparted
compas125817062compa_s
compass13379562compass
compere134616622compere
complot13310682complot
comports143411982comports
compost134515352compost
compt116328222comp__t
cowpat13312032cowpa_t
impart102715142_impart
rampart11311992rampart
apart74330673__apart
boart78835933bo__art
bogart9617193bo_gart
bombard1437333bombard
bombast1348223bombast
camper124722213camper_
campers134220293campers
campout13412853campout
carport11316033carport
cart66570343c___art
chart105038283c__hart
chomper163810073chomper_
chompers17369593chompers
coact96130583co__act
coapt96131533co__apt
coast75236273co__ast
coat67558353co__a_t
cobalt10317393co_balt
coempt12311033coemp__t
coenact11311803coenact
coexert16312363coexert
cohort1110720263co_hort
collar83816173collar_
collard103712923collard
collaret103116703collaret
collars93816573collars
coma87134853com_a__
comade114415323com_ade
comae97128423com_a_e
comake144413423com_ake
comal95125133com_a_l
comas95833003com_a_s
comate104124843com_ate
combats13311683combats
comber125118503comber_
combers134516623combers
combust1338363combust
comer95832693com_er_
comers105328083com_ers
comet95946073com__et
cometary1547693cometary
comfit133112423com_fit
comforts15347323comforts
comma114514793comma__
command14399213command
commas124814573comma_s
commata1338483commata
comment1310317703comment
commit124016703com_mit
commixt20357623commixt
comp106731253comp___
compacted18297363compacted
compacter17257883compacter
compactly2043823compactly
compactor17256023compactor
compadres16266413compadres
comparator1665803comparator
comparers15319393comparers
comparing162410583comparing
comparting17188383comparting
compatriot1655963compatriot
comped135919873comp_ed
compeer133811553compeer
compeers143410013compeers
compel124412893comp_el
compels133210893compels
compend144010303compend
compered153414923compered
comperes143217973comperes
compete134716553compete
compile13312443compile
comping143518593comping
complain1448763complain
complaint15410253complaint
compleat14710153compleat
complect1659013complect
complete143412053complete
complex2037243complex
compliant1549663compliant
complin13312073complin
complots1438163complots
comply152810383comp_ly
compo115318573comp__o
compone136517193compone
compony1613011913compony
comported16319533comported
compos124818803comp_os
compose135716663compose
composts144210913composts
compote135616463compote
comps115526053comp__s
compted143813523compted
compts125216653comp_ts
compute134513663compute
comrade12139213comrade
concert113325223concert
consort91319903consort
contact1144020683contact
contort91422343contort
convert123721473convert
coolant9316463coolant
cooper104221123cooper_
coopers114019483coopers
coopery143910273coopery
coopt95929853coop__t
copal95621783co_pa_l
copalm125010813co_palm
copals105018943co_pals
coparent12412253co_parent
copay126516313co_pa_y
copays134911273co_pays
coper95336093co_per_
copers104629843co_pers
coplot10518273co_plot
copout10418783co_pout
copper124321893copper_
coppers133519753coppers
coppery16409393coppery
coppra12306833co_ppra
coppras13327833coppras
copra98115463co_p_ra
coprah133710603co_prah
copras103517153co_pras
corpora1139353corpora
costar85518613costar_
costard104113353costard
costars94218013costars
cottar84613813cottar_
cottars94412243cottars
cougar958783cougar_
cougars1038443cougars
couplet114717943couplet
courant9317973courant
court75532773co__urt
covary1438743co_vary
covert114925503co_vert
coward12411673co_ward
cowpats1437713cowpats
cymar125711263cym_ar_
cymars13599153cym_ars
depart94720563_depart
dispart101115283dispart
dogcart1148043dogcart
dopant9316133do_pant
dumpcart1543463dumpcart
forepart1349703forepart
gosport101010283gosport
homeport15148943homeport
impact122310453_impact
impark14287073_impark
imparts11298533_imparts
import102713763_import
incompact1754353incompact
mart66865983__m_art
mispart111113783mispart
nonart6319193no_nart
nonpar8168993nonpar_
nonparty1345553nonparty
nonpast939033nonpast
oompah1334253oompa_h
oompahs1434263oompahs
oxcart1539523_oxcart
part65967463___part
pompano1345203pompano
rampant11312173rampant
ramparts1245583ramparts
romper104213683romper_
rompers113412243rompers
smart75834093_sm_art
subpart11311123subpart
tomcat101013453tomca_t
topmast1138123topmast
tripart9311433tripart
wombat1339863womba_t

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271987.03019065.0
3Display Results1981980.0633142.9
 (SQL Overall)1786911987.49923828.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.