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

193 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
parser8482237(None) 
parer75839901par_er
parker124121371parker
parse75236991parse_
parsec105914481parsec
parsed96323891parsed
parsers94118151parsers
parses85534701parses
passer84721031passer
pauser84415961pauser
purser85020471purser
sparser94311481sparser
armer76924442_armer
arse46539272_arse_
arses55733872_arses
barber104419322barber
barer74535802bar_er
barker124822862barker
barter85525372barter
baser74828922ba_ser
carder94524182carder
career85822242career
carer74942332car_er
carper104923632carper
carse74934332carse_
carses85233652carses
carter84932272carter
carver114420142carver
causer84117782causer
coarser93211202coarser
curser84721472curser
darer65230792dar_er
darker114718692darker
darner74017302darner
darter75320362darter
dorser74819182dorser
earner63617222earner
eraser64216332eraser
falser93912412falser
farcer115016082farcer
farer86733142far_er
farmer115017372farmer
garner73917002garner
garter74420512garter
gasser75017772gasser
harder105022402harder
harmer114719552harmer
harper115018402harper
harsher13310362harsher
hawser125910842hawser
hoarser10388392hoarser
kaiser103610372kaiser
lapser84113142lapser
larder73720972larder
larger74417512larger
larker104519242larker
laser54633322la_ser
marker124420392marker
marrer83716672marrer
marse76231152marse_
marses84827112marses
maser75029972ma_ser
nurser64314502nurser
pacer96131612pa_cer
pacier105018682pacier
packer144223402packer
padder103415492padder
pager84728202pa_ger
paise75028332paise_
paler75436932pa_ler
palier85023562palier
palmer105816542palmer
palter84423262palter
pamper124316662pamper
pander93725522pander
panier84425502panier
panner84224762panner
panzer174213232panzer
paper95128662pa_per
parader103914862parader
parae76335702parae_
parcel103915472parcel
pardee93922022pardee
pardner10239472pardner
pare66760842par_e_
pared86946762par_ed
pareo74632602par_eo
parers85530742par_ers
pares77164482par_es
pareses94718882pareses
pareu74928742par_eu
parge85831852parge_
parged104922042parged
parges94529542parges
parget94529392parget
paries84742512paries
parises94827182parises
parked134425142parked
parkers133816872parkers
parle75836162parle_
parled94626292parled
parles86334402parles
parley116718362parley
parlor8312672parlor
parr65731152par__r
parred95024072parred
parrel84515982parrel
parrier93717652parrier
pars67560792pars__
parsecs11429922parsecs
parsley1247802parsley
parson83817902parson
parted94228682parted
partier93520712partier
partner92811392partner
partyer12337872partyer
parure8312522parure
parve109824852parve_
pase65346862pa_se_
paseo77022512pa_seo
pases75346502pa_ses
passe75525692passe_
passed94320942passed
passee84522022passee
passel85117002passel
passers94717752passers
passes86030472passes
paster85734372paster
pater74740722pa_ter
patter84628262patter
patzer173111642patzer
pauper103511942pauper
pause75021832pause_
paused95114962paused
pausers94113222pausers
pauses84621472pauses
paver104225832pa_ver
paviser12489092paviser
pawer104422972pa_wer
pawner114212922pawner
payer105125722pa_yer
pearler9310372pearler
pearter9412742pearter
perse75429522perse_
perses85428062perses
perter84422282perter
peruser93511372peruser
pisser84416382pisser
poiser84217242poiser
porker124917542porker
porter84224412porter
poser75128772p_oser
praiser93413942praiser
prase76128752prase_
prases84429022prases
prater84825352prater
prayer114815292prayer
prier75027762p_rier
proser84223462proser
pryer104415312p_ryer
pulser84215192pulser
purer75127902pur_er
purger94717232purger
purse76028892purse_
pursed95220882pursed
pursers93916092pursers
purses84826372purses
pursier94012752pursier
pursuer9338892pursuer
raiser66620102raiser
rarer54731702rar_er
raser55633412ra_ser
sarsar63011842sarsar
sarsen6314232sarsen
sparer84524962spar_er
sparger103613082sparger
sparker133914362sparker
sparse84516342sparse_
tarsier74119252tarsier
tarter64023562tarter
terser67317822terser
varier94619352varier
verser94516962verser
warder104020272warder
warier93722892warier
warmer113816732warmer
warner93717222warner
warper114015582warper
warsler10289892warsler
worser95117522worser
yarder103813972yarder
yarer84321572yar_er
yarner93313062yarner

Search took 3 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 Filter178691825510.360496363.9
2DLD Change Limit825511932.50033020.4
3Display Results1931930.0633063.5
 (SQL Overall)1786911932.92361132.7
 
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.