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

310 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
pears7513861(None) 
bears75739041bears
dears65736881dears
ears46356591_ears
fears84829391fears
gears64628691gears
hears86737371hears
lears55938731lears
nears55529421nears
pars67560791p_ars
peags86122841peags
peaks114825621peaks
peals75235491peals
peans75437641peans
pear69745231pear_
pearl75324461pearl
pearls84715391pearls
peart76440751peart
peas65755061pea_s
peats76140191peats
peers75130271peers
rears54739651rears
sears54744911sears
spears84019471spears
tears55436461tears
wears86030301wears
years84527671years
afars85716512afars
agars66120642agars
anears63717182anears
apers76629132ape_rs
appears11308952appears
ars37670932__ars
bars66564092_bars
beads85429502beads
beaks115326622beaks
beams95328172beams
beans75734692beans
bear66844642bear_
beard86024962beard
beards94116672beards
beats76042242beats
beaus75127112beaus
beers75628392beers
blears85116452blears
boars75229602boars
cars67364762_cars
cedars93312832cedars
chars105936642chars
clears84116562clears
czars164812912czars
deads75726912deads
deairs74013782deairs
deals65435342deals
deans66131392deans
dear55343602dear_
deary95826842deary
debars94218042debars
deers64930522deers
denars74621432denars
dewars105117072dewars
drears74614252drears
ear36867882_ear_
earl45838142_earl
earls56127512_earls
earn46737552_earn
earns55927562_earns
eats47054872_eats
eras45441502_eras
errs45622532_errs
ers36046282_e_rs
fear75337792fear_
feats86432752feats
feuars938652feuars
fiars86720832fiars
gars55750742_gars
gear55934972gear_
gnars66718852gnars
guars65021052guars
haars85620472haars
heads95127112heads
heals85733452heals
heaps105223222heaps
hear76143882hear_
heard95222752heard
hearse94114272hearse
heart85440742heart
hearts96218942hearts
heats85838402heats
heirs85618562heirs
hers75844872he_rs
hoars85925552hoars
izars145112932izars
jars117338352_jars
jeans126022112jeans
jeers124818132jeers
kbars114612602kbars
keas86337092kea_s
kebars124112492kebars
keirs95313672keirs
knars94416112knars
kyars124813962kyars
lars46956572_lars
leads66028492leads
leafs85721182leafs
leaks95923912leaks
leans55536252leans
leaps75522932leaps
lear47045952lear_
learn55322662learn
learns65513742learns
leary85927382leary
leas45954182lea_s
leers54828982leers
lehrs86111132lehrs
liars54723162liars
maars74621632maars
mars66261862_mars
meads85425322meads
meals75933372meals
means75831222means
meats75034052meats
neaps75618322neaps
near45236502near_
neats55931902neats
oars46846032_oars
operas8312452operas
pacs85842182p_acs
pads76742952p_ads
paeans85118262paeans
pairs75325832pairs
pals66951352p_als
pams85641762p_ams
pans65855722p_ans
paps86443452p_aps
par57467022p_ar_
para65242172p_ara
paras76143042p_aras
pard76441322p_ard
pards85634332p_ards
pare66760842p_are
pares77164482p_ares
paris75145942p_aris
park105237492p_ark
parks116134462p_arks
parr65731152p_arr
parrs75928672parrs
parse75236992p_arse
part65967462p_art
parts77743372p_arts
pas58775742p_a_s
pass65239952p_ass
pats66460852p_ats
paws96038182p_aws
pays95940222p_ays
pea56657242pea__
peace95026082peace
peaces106324082peaces
peach125422492peach
peag75431342pea_g
peage84723562peage
peages94321842peages
peak106535202pea_k
peaky145718152peaky
peal68648102pea_l
pean66147172pea_n
pearly116414842pearly
pease75231112pease
peases85229472peases
peat65967932pea_t
peaty105725692peaty
peavy135014842peavy
pecans101515832pecans
pechs125516202pechs
pecks135724432pecks
pecs84634102pe_cs
pedals94316032pedals
pedes85327282pedes
pedlars103210212pedlars
pedro8313152pedro
pedros9312182pedros
peds75835242pe_ds
peeks115021112peeks
peels75226422peels
peens76428192peens
peeps95822362peeps
peer66238352peer_
peery105719442peery
pees65257372pe_es
pegs75531762pe_gs
pehs95625762pe_hs
peins76128062peins
pekans121710552pekans
pekes114623562pekes
peles75738082peles
pelfs105016292pelfs
pelts76128812pelts
pends85527192pends
penes75839222penes
penis75129322penis
pens65649642pe_ns
peons75327182peons
pepos96620082pepos
peps85134512pe_ps
per56353092pe_r_
pere66450262pe_re
peres76246642peres
peri65636972pe_ri
peris75537072peris
perk106232842pe_rk
perks115325802perks
perm85834632pe_rm
perms95524512perms
perp89029892pe_rp
perps95521482perps
perry105222712perry
perse75429522pe_rse
pert66759322pe_rt
perv97224812pe_rv
pervs105117372pervs
pes57259782pe__s
pesos77221622pesos
pests75933272pests
petals84719812petals
petard95013802petard
petards104311152petards
peters86624592peters
pets66248332pe_ts
pews95731532pe_ws
pharos11312062pharos
pians75126962pians
pias66542552pia_s
piers75926332piers
plans75731272plans
plats75531372plats
plays106320772plays
pleads94613952pleads
pleas75627032plea_s
pleats85218592pleats
polars84419352polars
pours74623182pours
prams96125512prams
praos74923562praos
prats76333392prats
praus74621752praus
prays105022432prays
prearm104512342prearm
prearms11369172prearms
purrs75320432purrs
purs65641042p_urs
pyas96225702pya_s
reads64835272reads
reals55038652reals
reams75729622reams
reaps75626192reaps
rear45644552rear_
rearm75923562rearm
rearms85114652rearms
rebars84019832rebars
roars55622242roars
scars75433532scars
seals54839692seals
seams75731662seams
sear47353842sear_
seas45755272sea_s
seats54844342seats
seers55136382seers
sers45746652se_rs
sewars94018622sewars
shears93820902shears
smears84714432smears
soars54732512soars
spars75431542spars
speaks125114582speaks
speans85417142speans
spear75821062spear_
speers85019952speers
speirs85013232speirs
stars55836572stars
swears94114072swears
tars46763952_tars
teaks94222902teaks
teals56234132teals
teams75726512teams
tear45242882tear_
teary85124052teary
teas45851492tea_s
teats55636812teats
tsars56717112tsars
tzars144914272tzars
upbears1195422upbears
uprears9107492uprears
uptears9106452uptears
vars75742072_vars
veals84926192veals
veers84521362veers
velars93913722velars
wars78659802_wars
weals85428742weals
weans85326742weans
wear75836722wear_
weary115620612weary
weirs84316492weirs
yeahs115214552yeahs
yeans86624882yeans
year76534252year_
yearn86316432yearn
yearns9509542yearns
yeas78638422yea_s
zeals145320852zeals

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.1401276364.3
2DLD Change Limit538003101.75030742.9
3Display Results3103100.0933333.3
 (SQL Overall)1786913101.98390111.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.