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

181 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
composer14501295(None) 
compose135716661compose_
composed154612061composed
composers153910621composers
composes145017111composes
composter15369561composter
cocomposer1853322cocomposer
commoner142710632commoner
comose105016842com_ose_
comparer143611362comparer
compeer133811552comp_eer
compiler1438372compiler
complier14310252complier
compone136517192compone_
compos124818802compos__
compost134515352compos_t
composted16378812composted
composters16388322composters
composts144210912composts
composure1545122composure
compote135616462compote_
compotes144716512compotes
computer144511512computer
decomposer1753492decomposer
imposer113310102_imposer
opposer1135772_opposer
apposer1147483_apposer
camper124722213camp__er
campier133313273camp_ier
camporee1449343camporee
campos125217953campos__
campused1535253campused
campuses1437773campuses
chomper163810073chomp__er
chooser124412973c_hooser
closer84918203c__loser
coarser93211203co_arser
cocomposers1952643cocomposers
colorer9312523co_lorer
comaker153410603com_aker
comatose1247823comatose_
combater1439383combater
comber125118503com__ber
combiner14259723combiner
combos125316613combos__
comelier12310653comelier
comember1644163comember
comer95832693com___er
comether1537253comether
comfier1439163com_fier
comforter16255983comforter
commode1438123commode_
commodes1539093commodes
commoners15339783commoners
commove1635963commove_
commoved1844763commoved
commoves1736963commoves
communer14349303communer
commuter143010153commuter
comonomer1545023comonomer
compacter17257883compacter
compadre15295883compadre
compare135814993compare_
compared153811823compared
comparers15319393comparers
compares143816433compares
compas125817063compas__
compass13379563compas_s
compassed1645543compassed
compasses1547393compasses
comped135919873comp__ed
compeers143410013comp_eers
compel124412893comp__el
compeller1546293compeller
compere134616623comp__ere
compered153414923compered
comperes143217973comperes
compete134716553compete_
competed154113593competed
competes144117243competes
compile13312443compile_
compiled1537813compiled
compilers1537053compilers
compiles14311983compiles
completer153310413completer
complex2037243comp_lex
complexer22316213complexer
complied1539673complied
compliers1538293compliers
complies14314523complies
compo115318573compo___
component15411083component
compony1613011913compo_ny
comport133616843compo_rt
comported16319533comported
comports143411983comports
composedly2053003composedly
composing16179843composing
composite15410153composite
composited1756003composited
composites1648903composites
compositor1644633compositor
composures1645133composures
compound1555993compound
compounder1743433compounder
compress1439053compress
comprise14310813comprise_
comprised1648053comprised
comprises15510943comprises
compromiser1952623compromiser
comps115526053comp_s__
compted143813523comp_ted
compts125216653compts__
compute134513663compute_
computed154110953computed
computers15339753computers
computes143914553computes
conciser12310243conciser
condoler113412123condoler
condoner112913413condoner
conioses10313313conioses
consoler102812613consoler
convoker17226903convoker
cooer74831013co__o_er
cooker124722453co__oker
cooler84824713co__oler
cooper104221123co__oper
cooter85128613co__oter
coper95336093co_p__er
copier103722893co_p_ier
copper124321893co_p_per
copse95623923co_p_se_
copses104922473co_p_ses
copter109822013co_p_ter
coroner94218203co_roner
corpse104013403corp_se_
corpses113913803corp_ses
corpuses12310063corpuses
cosmoses1239703cosmoses
cosponsor1342593cosponsor
coupler114713013coup_ler
courser94114803co_urser
cowpoke1835103cowpoke_
cowpokes1944573cowpokes
cowpoxes2244513cowpoxes
cymose13429653cym_ose_
decompose1644543decompose_
decomposed1843893decomposed
decomposers1852503decomposers
decomposes1745193decomposes
deposer104011843_deposer
disposer11310413disposer
empower14217033_empower
exposer1637413_exposer
gomphoses1745833gomphoses
hommoses1538153hommoses
homosex1936123hom_osex
impose103113053_impose_
imposed123110293_imposed
imposers12278463_imposers
imposes113213683_imposes
imposter12288163_imposter
impower14247123_impower
looser65219943lo__oser
momser104011413mom__ser
noncomposer1753723noncomposer
nooser65517823no__oser
oppose1039193_oppose_
opposed1236123_opposed
opposers1244973_opposers
opposes1149243_opposes
popover1495843po_pover
poser75128773___poser
proposer121810633proposer
recompose1545293recompose_
recomposed1744863recomposed
recomposes1646063recomposes
reposer93715333_reposer
romper104213683romp__er
rooser63921883ro__oser
supposer1245593supposer

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 Filter1786911461620.546327272.9
2DLD Change Limit1461621818.18617855.1
3Display Results1811810.0802262.5
 (SQL Overall)1786911818.81220278.1
 
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.