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

153 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
composts14421091(None) 
comports143411981comports
composes145017111composes
compost134515351compost_
campouts1436822campouts
cohosts12398812co_hosts
combusts1445502combusts
comforts15347322comforts
compacts16368902compacts
comparts144210832comparts
compass13379562compas_s
complots1438162complots
comport133616842comport_
compos124818802compo__s
compose135716662compos_e
composed154612062composed
composer145012952composer
composers153910622composers
composite15410152composite
composites1648902composites
composted16378812composted
composter15369562composter
composters16388322composters
compote135616462compo_te
compotes144716512compotes
compts125216652comp__ts
copouts11311082co_pouts
imposts11269002_imposts
airposts1045923airposts
bedposts1343873bedposts
bombasts1444953bombasts
boosts86115013bo__osts
bowpots1446023bowpo_ts
cambists1437023cambists
campongs15356123campongs
campos125217953campo__s
campout13412853campout_
campuses1437773campuses
carports1238943carports
coapts104614013coap__ts
coasts85719143co__asts
coempts1335683coemp__ts
coexists1735653coexists
cohorts123411103co_horts
cohost115217213co_host_
combats13311683com_bats
combos125316613combo__s
combust1338363combust_
comets105823583com__ets
comfits14328743com_fits
comfort143611693comfort_
comments142913883comments
commits133812383com_mits
commodes1539093commodes
commons13311043commo_ns
commoves1736963commoves
comose105016843com_os_e
comous10816503com_o_us
compact153712213compact_
compares143816433compares
compart134016003compart_
compas125817063comp__as
compasses1547393compasses
compeers143410013compeers
compels133210883comp_els
compends15378253compends
comperes143217973comperes
compete134716553comp_ete
competes144117243competes
compiles14311983compiles
complects1766413complects
complete143412053complete
completes153212923completes
complies14314523complies
complins14313113complins
complot13310683complot_
compo115318573compo___
compone136517193compo_ne
components1646943components
compony1613011913compo_ny
comported16319533comported
composing16179843composing
composited1756003composited
compositor1644633compositor
compositors1754383compositors
composting17178053composting
composure1545123composure
composures1645133composures
compound1555993compound
compounds1654503compounds
compress1439053compress
comprises15510943comprises
comps115526053comp___s
compt116328223comp__t_
compute134513663comp_ute
computes143914553computes
computists1644693computists
concocts1138633concocts
congests113510383congests
conioses10313313conioses
coniosis1048133coniosis
consists10310593consists
consorts101512343consorts
contests103413383contests
contorts101112643contorts
cookouts1446003cookouts
coopts105814583co__opts
coots75636843co__o_ts
coplots11511593co_plots
copout10418783co_pout_
copses104922473co_p_ses
copyists1545993copyists
corposants1444643corposants
corpses113913803corp_ses
corpuses12310063corpuses
cosmists1237993cosmists
cosmoses1239703cosmoses
costs77231143c___osts
couplets12389873couplets
coupons112710563coupo_ns
cowpats1437713cowp_ats
cowpokes1944573cowpokes
cowpoxes2244513cowpoxes
coypous14248813coypo_us
decomposes1745193decomposes
doorposts1272993doorposts
goalposts1252163goalposts
gomphoses1745833gomphoses
gomphosis1744453gomphosis
gosports1185913gosports
homeports16115553homeports
hommoses1538153hommoses
imports11309623_imports
imposes113213683_imposes
impost103011783_impost_
lampposts1542153lampposts
mosts76028543__m_osts
nonpasts1046553nonpasts
opposes1149243_opposes
outposts1037253outposts
pompoms1535333pompo_ms
pompons1338553pompo_ns
pomposity1844653pomposity
pompous1338063pompo_us
posts75228783___posts
recomposes1646063recomposes
riposts9279403_riposts
roosts64916323ro__osts
tempests1234443tempests
topmasts1244973topmasts
topmost1148173topmost_
utmosts934593utm_osts
volosts1036563vo_losts

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.453394461.4
2DLD Change Limit1461621537.11020557.2
3Display Results1531530.0602550.0
 (SQL Overall)1786911537.62323441.0
 
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.