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

132 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
composers15391061(None) 
composer145012951composer_
composes145017111compose_s
composters16388311composters
cocomposers1952642cocomposers
commoners15339782commoners
comparers15319382comparers
compeers143410012comp_eers
compilers1537052compilers
compliers1538292compliers
compose135716662compose__
composed154612062compose_d
composter15369562composter_
composts144210912compos_ts
composure1545112composure
composures1645122composures
compotes144716512compote_s
computers15339732computers
decomposers1852502decomposers
imposers12278452_imposers
opposers1244972_opposers
apposers1236283_apposers
campers134220283camp__ers
camporees1546103camporees
campuses1437773campuse_s
chompers17369573chomp__ers
choosers134810863c_hoosers
closers94415313c__losers
cocomposer1853323cocomposer_
colorers10312183co_lorers
comakers16339163com_akers
combaters1538093combaters
combers134516613com__bers
combiners15247943combiners
comembers1744223comembers
comers105328083com___ers
comethers1637433comethers
comforters17275193comforters
commodes1539093commode_s
commoner142710633commoner_
commoves1736963commove_s
communers15338403communers
commuters15378883commuters
comonomers1644523comonomers
comose105016843com_ose__
compacters18247013compacters
compadres16266413compadres
comparer143611363comparer_
compares143816433compare_s
compass13379563compas__s
compasses1547393compasses
compeer133811553comp_eer_
compellers1645193compellers
compels133210883comp__els
compere134616623comp__ere
comperes143217973comp__eres
competes144117243compete_s
compiler1438373compiler_
compiles14311983compile_s
completers16298323completers
complier14310253complier_
complies14314523complie_s
compone136517193compone__
component15411083component
components1646943components
comport133616843compo__rt
comports143411983compo_rts
compos124818803compo___s
composedly2052993composedly
composing16179843composing
composite15410153composite
composites1648893composites
compositors1754383compositors
compost134515353compos__t
composted16378813composted
compote135616463compote__
compounders1843143compounders
compounds1654503compounds
compress1439053comp_ress
comprises15510943comprise_s
compromisers2051953compromisers
computer144511503computer_
computes143914533compute_s
condolers122710563condolers
condoners122811493condoners
conioses10313313coniose_s
consolers112510923consolers
convokers18246103convokers
cooers84324563co__o_ers
cookers134619463co__okers
coolers93522493co__olers
coopers114019483co__opers
cooters94525713co__oters
copers104629843co_p__ers
copiers114215963co_p_iers
coppers133519753co_p_pers
copses104922473co_p_se_s
copters113621273co_p_ters
coroners104016223co_roners
corpses113913803corp_se_s
corpuses12310063corpuse_s
cosmoses1239703cosmose_s
cosponsors1452813cosponsors
couplers123311313coup_lers
coursers104412293co_ursers
cowpokes1944573cowpoke_s
cowpoxes2244513cowpoxe_s
decomposer1753493decomposer_
decomposes1745193decompose_s
deposers11359243_deposers
disposers1238363disposers
empowers15276843_empowers
exposers1736133_exposers
gomphoses1745833gomphose_s
hommoses1538153hommose_s
imposer113310103_imposer_
imposes113213683_impose_s
imposters13347333_imposters
impowers15296823_impowers
momsers113810843mom__sers
noncomposers1853273noncomposers
noosers74913913no__osers
opposer1135773_opposer_
opposes1149243_oppose_s
popovers1595663po_povers
posers84223973___posers
proposers13228523proposers
recomposes1646063recompose_s
reposers102911603_reposers
rompers113412243romp__ers
roosers74217873ro__osers
supposers1344533supposers

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 Filter1786911486410.1701051123.5
2DLD Change Limit1486411328.00318573.2
3Display Results1321320.0602200.0
 (SQL Overall)1786911328.23321704.2
 
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.