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 “parsers” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

144 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
parsers9411815(None) 
parers85530741par_ers
parkers133816871parkers
parsecs11429921parsecs
parser84822371parser_
parses85534701parse_s
passers94717751passers
pausers94113221pausers
pursers93916091pursers
armers85520272_armers
arses55733872_arse_s
barbers114317502barbers
barkers134318512barkers
barters94223032barters
carders104820352carders
careers95218782careers
carers85133962car_ers
carpers114521252carpers
carses85233652carse_s
carters95327252carters
carvers124817532carvers
causers94014792causers
cursers94317162cursers
darers75921872dar_ers
darners83815772darners
darters84017602darters
dorsers83516302dorsers
earners74016452earners
erasers74413942erasers
farcers124713442farcers
farers95924052far_ers
farmers124315262farmers
garners83815982garners
garters84218232garters
gassers84714632gassers
harmers124116592harmers
harpers124916202harpers
hawsers13409482hawsers
kaisers11369272kaisers
lapsers93911052lapsers
larders83516942larders
larkers113014512larkers
lasers64925702la_sers
markers133516102markers
marrers93414312marrers
marses84827112marse_s
masers84623452ma_sers
nursers74311832nursers
pacers105124542pa_cers
packers153818892packers
padders113312872padders
pagers94423252pa_gers
palmers113513622palmers
palters94021682palters
pampers133615932pampers
panders103423732panders
paniers94717332paniers
panners93621272panners
panzers184012012panzers
papers105125322pa_pers
paraders113113112paraders
parcels113712662parcels
pardners11269192pardners
pareos87023772par_eos
parer75839902par_er_
pares77164482par_e_s
pareses94718882pareses
paresis93315092paresis
pareus85420742par_eus
parges94529542parge_s
pargets105215192pargets
paries84742512parie_s
parises94827182parise_s
parker124121372parker_
parles86334402parle_s
parleys125212372parleys
parlors9312912parlors
parrels94713492parrels
parriers103612902parriers
parrs75928672par__rs
parse75236992parse__
parsec105914482parse_c
parsed96323892parse_d
parsleys1335082parsleys
parsons93516872parsons
partiers103514242partiers
partners102711132partners
partyers13277762partyers
parures9512692parures
paseos88015812pa_seos
pases75346502pa_se_s
passels93913022passels
passer84721032passer_
passes86030472passe_s
pasters94531732pasters
paters84935832pa_ters
patters94825192patters
patzers184210572patzers
paupers114311072paupers
pauser84415962pauser_
pauses84621472pause_s
pavers115021822pa_vers
pavisers13387442pavisers
pawers114818782pa_wers
pawners124311072pawners
payers114621822pa_yers
pearlers1039032pearlers
perses85428062perse_s
perusers10328802perusers
pissers95014752pissers
poisers94214432poisers
porkers134314932porkers
porters93722702porters
posers84223972p_osers
praisers103410832praisers
prases84429022prase_s
praters94921652praters
prayers124212852prayers
priers84521192p_riers
prosers94219642prosers
pryers115012242p_ryers
pulsers94213152pulsers
purgers104714002purgers
purser85020472purser_
purses84826372purse_s
pursuers10376522pursuers
raisers73617392raisers
rasers64526782ra_sers
sarsars73512142sarsars
sarsens7311392sarsens
sparers94519612spar_ers
spargers11389732spargers
sparkers144111312sparkers
sparser94311482sparser_
tarsiers8298532tarsiers
variers103712662variers
versers103813522versers
warders113416812warders
warmers124514292warmers
warners103315562warners
warpers123413582warpers
warslers11328072warslers
yarders113211592yarders
yarners104312202yarners

Search took 4 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 Filter1786911076710.373479064.3
2DLD Change Limit1076711443.43631336.1
3Display Results1441440.0502880.0
 (SQL Overall)1786911443.85946305.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.