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

156 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
comparer14361136(None) 
compare135814991compare_
compared153811821compared
comparers15319391comparers
compares143816431compares
comaker153410602com_aker
combater1439382combater
compacter17257882compacter
compadre15295882compadre_
compadres16266412compadres
compart134016002compar_t
comparted16338422comparted
comparts144210832comparts
compeer133811552comp_eer
compere134616622compere_
compered153414922compered
comperes143217972comperes
compiler1438372compiler
complier14310252complier
composer145012952composer
computer144511512computer
bombarder16143583bombarder
camper124722213camp__er
campier133313273camp_ier
camporee1449343camporee
caperer113013403c_aperer
capmaker1855203capmaker
carer74942333c___arer
cellarer10317923cellarer
chomper163810073chomp__er
clearer93710823c_learer
coaler84121713co__aler
coarser93211203co__arser
coater84329573co__ater
coaxer153912793co__axer
coherer122912783co_herer
coleader1139183coleader
collared113211143collared
collaret103116703collaret
colorer9312523co_lorer
colourer1037563colourer
comade114415323com_ade_
comae97128423com_a_e_
comake144413423com_ake_
comakers16339173com_akers
comakes154413643com_akes
comanager1444533comanager
comate104124843com_ate_
comates114123643com_ates
combated1539823combated
combaters1538113combaters
comber125118503com__ber
combiner14259723combiner
comelier12310653comelier
comember1644163comember
comer95832693com___er
comether1537253comether
comfier1439163com_fier
comforter16255983comforter
comfrey1734683com_frey
commander16127403commander
commoner142710633commoner
communer14349303communer
commuter143010153commuter
compact153712213compa_ct
compacted18297363compacted
compacters18247023compacters
compactor17256023compactor
compacts16368903compacts
companied1648023companied
companies15311803companies
company1619711143compa_ny
comparator1665803comparator
comparing162410583comparing
compas125817063compa__s
compass13379563compa_ss
compassed1645543compassed
compasses1547393compasses
comped135919873comp__ed
compeered1646303compeered
compeers143410013compeers
compel124412893comp__el
compeller1546293compeller
compete134716553compete_
competed154113593competed
competes144117243competes
compile13312443compile_
compiled1537813compiled
compilers1537053compilers
compiles14311983compiles
complainer1645693complainer
completer153310413completer
complex2037243comp_lex
complexer22316213complexer
complied1539673complied
compliers1538293compliers
complies14314523complies
compone136517193compone_
comport133616843compor_t
comported16319533comported
comports143411983comports
compose135716663compose_
composed154612063composed
composers153910623composers
composes145017113composes
composter15369563composter
compote135616463compote_
compotes144716513compotes
comprador1643593comprador
compress1439053comp_ress
compted143813523comp_ted
compute134513663compute_
computed154110953computed
computers15339753computers
computes143914553computes
comrade12139213comrade_
comradery1793493comradery
comrades13149773comrades
conjurer17117683conjurer
conspirer1355293conspirer
cooper104221123coop__er
coopered133310933coopered
coparent12412253co_parent
copartner1343563co_partner
coper95336093co_p__er
copier103722893co_p_ier
copper124321893co_p_per
coppered153410543coppered
copter109822013co_p_ter
corer75538873co___rer
cottager11306813cottager
coupler114713013coup_ler
coverer123113523co_verer
cumberer14266993cumberer
cymbaler1743113cymbaler
empaler11288353_empaler
hamperer15379093hamperer
homager13107853hom_ager
impairer1244863_impairer
impaler11298393_impaler
imparter12357543_imparter
impurer1136483_impurer
oompahed1642903oompahed
pamperer14228333pamperer
parer75839903___parer
preparer12169643preparer
rampager1344453rampager
roarer63914333ro__arer
romper104213683romp__er
scamperer1544623scamperer
simperer1237173simperer
smearer94110403_smearer
soarer64522243so__arer
sparer84524963__sparer
tamperer12248893tamperer
temperer12227723temperer

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 Limit1461621566.79621507.1
3Display Results1561560.0632476.2
 (SQL Overall)1786911567.31224438.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.