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

282 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
parrs7592867(None) 
carrs75730851carrs
pairs75325831pairs
paras76143041paras
pards85634331pards
parers85530741parers
pares77164481pares
paris75145941paris
parks116134461parks
parr65731151parr_
parry105323751parry
pars67560791pa_rs
parts77743371parts
purrs75320431purrs
airs46447422_airs
apers76629132apers
apres75426402apres
arbs66834732_arbs
arcs67834782_arcs
ares45871022_ares
arfs76029962_arfs
arks85936872_arks
arms66137492_arms
arras55626132_arras
arris56824682_arris
ars37670932_a_rs
arts49650262_arts
barbs95928192barbs
bards87139642bards
bares75457132bares
barfs104826002barfs
barks115735812barks
barms96128462barms
barns76335142barns
barre75929542barre
barres84427542barres
bars66564092ba_rs
birrs74917102birrs
burrs74925652burrs
carbs96031462carbs
cards85137932cards
carers85133962carers
cares77369182cares
carks115534212carks
carls77037422carls
carns75937562carns
carps96932252carps
carr65434702carr_
carry105823782carry
cars67364762ca_rs
carts78946292carts
charrs115219192charrs
currs75624392currs
darbs85323262darbs
darers75921872darers
dares66146702dares
darks106727872darks
darns66927892darns
darts67635732darts
dorrs65520592dorrs
durrs65519992durrs
earls56127512earls
earns55927562earns
ears46356592ea_rs
errs45622532_errs
fairs85825442fairs
fards96629842fards
farers95924052farers
fares85852872fares
farls85731112farls
farms106324952farms
faros85532022faros
farts88336842farts
garbs86321412garbs
gars55750742ga_rs
gaurs66317992gaurs
gnarrs7407662gnarrs
haars85620472haars
hairs86225172hairs
hards96435652hards
hares86255542hares
harks126333432harks
harls85634502harls
harms106829012harms
harps105926872harps
harry115322952harry
harts88441592harts
jarls126120962jarls
jars117338352ja_rs
karns96624142karns
karts97630112karts
lairs55425872lairs
lards65331862lards
lares54852632lares
laris54737462laris
larks95227812larks
lars46956572la_rs
maars74621632maars
mairs76228302mairs
maras75443292maras
marcs95726622marcs
mares76457632mares
marks115933482marks
marls75535162marls
marry104821692marry
mars66261872ma_rs
marts77442232marts
murrs75521302murrs
narcs76122022narcs
nards65928462nards
nares55544152nares
naris55735292naris
narks96026032narks
oars46846032oa_rs
pacas96029402pacas
pacers105124542pacers
paces96741112paces
packs135528932packs
pacs85842182pa_cs
pacts95125802pacts
padis86227142padis
padre86018162padre
padres95016982padres
padri85815172padri
pads76742952pa_ds
pagers94423252pagers
pages85235072pages
paiks114719852paiks
pails75833062pails
pains75138282pains
pair66031512pair_
pales75753802pales
palls74332562palls
palms94921752palms
palps94719562palps
pals66951352pa_ls
pams85641762pa_ms
panes76148692panes
pangs84628672pangs
pans65855732pa_ns
pants76536922pants
papas94927492papas
papers105125322papers
paps86443452pa_ps
par57467022pa_r_
para65242172pa_ra
parae76335702parae
parch125123002parch
pard76441322pa_rd
pardi85723952pardi
pardy115523952pardy
pare66760842pa_re
pared86946762pared
pareo74632602pareo
pareos87023772pareos
parer75839902parer
pareu74928742pareu
pareus85420742pareus
parge85831852parge
parges94529542parges
pargo86723722pargo
pargos95719042pargos
paries84742512paries
parish115022352parish
park105237492pa_rk
parka115120882parka
parkas125018022parkas
parkers133816872parkers
parle75836162parle
parles86334402parles
parlors9312912parlors
parol74826272parol
parols84722612parols
parous84024162parous
parral85517532parral
parrals94414572parrals
parred95024072parred
parrel84515982parrel
parrels94713492parrels
parries93925842parries
parrot8320662parrot
parrots9312742parrots
parse75236992parse
parsers94118152parsers
parses85534702parses
part65967462pa_rt
party106630612party
parura8310582parura
paruras9310532paruras
parure8312522parure
parures9512692parures
parve109824852parve
parvis116114802parvis
parvo107719182parvo
parvos116614752parvos
pas58775742pa__s
pases75346502pases
pass65239952pa_ss
pasts75936502pasts
paters84935832paters
pates76047892pates
paths105521382paths
pats66460852pa_ts
pavers115021822pavers
paves104833922paves
pavis106422732pavis
pawers114818782pawers
pawls105617662pawls
pawns108818132pawns
paws96038182pa_ws
paxes144928422paxes
payers114621822payers
payors114312642payors
pays95940222pa_ys
pearls84715392pearls
pears75138612pears
peers75130272peers
peres76246642peres
peris75537072peris
perks115325802perks
perms95524512perms
perps95521482perps
perry105222712perry
pervs105117372pervs
pharos11312062pharos
piers75926332piers
pirns76020092pirns
pores75849032pores
porks115124142porks
porns75527342porns
ports75934592ports
pours74623182pours
prams96125512prams
praos74923562praos
prats76333392prats
praus74621752praus
prays105022432prays
pros65742782p_ros
puris75332022puris
purls74723352purls
purr64925812purr_
purs65641042p_urs
pyres105523882pyres
pyros105718292pyros
rares55247442rares
sards64736182sards
saris54544952saris
sarks96632462sarks
saros55238062saros
sparers94519612sparers
spares84834552spares
sparks124616362sparks
sparry115111302sparry
spars75431542spa_rs
tahrs85412332tahrs
tares57456562tares
tarns56433952tarns
taros55640822taros
tarps76527122tarps
tarre55825632tarre
tarres64723042tarres
tarry85422512tarry
tars46763952ta_rs
tarts57242022tarts
torrs53923562torrs
vairs85019132vairs
varas86028192varas
vars75742072va_rs
varus85921182varus
wairs86424062wairs
wards97734402wards
wares88250582wares
warks127932402warks
warms107726852warms
warns87231002warns
warps107126422warps
wars78659802wa_rs
warts814840402warts
yards95324612yards
yarns85621792yarns
yirrs8469192yirrs
zarfs174713622zarfs

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 Filter178691538000.313570897.8
2DLD Change Limit538002821.65632487.9
3Display Results2822820.0763710.5
 (SQL Overall)1786912822.04587379.5
 
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.