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

269 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
pearlier103732(None) 
earlier72612741_earlier
nearlier836791nearlier
pearler9310371pearl_er
deadlier1036862deadlier
featlier1136452featlier
gnarlier9255162gnarlier
heartier1139092heartier
learier73415662lear_ier
marlier92614772_marlier
mealier93015902mea_lier
measlier1036012measlier
palier85023562p_a_lier
pallier94417162p_allier
parrier93717652p_arrier
partier93520712p_artier
peachier1548622peachier
peakier134411442pea_kier
pearled10411552pearl_ed
pearlers1039032pearl_ers
pearliest1139362pearliest
pearling11912012pearling
pearlite1039442pearlite
pearlites1138232pearlites
pearlized2145562pearlized
pearter9412742pear_ter
peatier94017232pea_tier
pebblier1453262pebblier
pedalier1137602pedalier
perkier133813122pe_rkier
snarlier8278182snarlier
tearier73815612tear_ier
vealier102712172vea_lier
weaklier1534262weaklier
wearier103613282wear_ier
yearlies1137602yearlies
aerier64823153ae_r_ier
artier63419733__artier
barkier133814483_barkier
barmier114313043_barmier
barnier93213673_barnier
barrier94017733_barrier
beachier1538803beachier
beadier103513913bea_dier
beakier134012163bea_kier
beamier113411943bea_mier
bearer85323913bear__er
bearlike14156793bearlike
beastlier1144203beastlier
beerier93613023beer_ier
belier84423563be__lier
blearier1037333blear_ier
brawlier13267043brawlier
burlier93514413_burlier
carrier93619583_carrier
charier124317903char_ier
charlie123011923charlie_
charlies133414233charlies
charrier1378683charrier
cleanlier1143363cleanlier
coalier93416183coa_lier
crawlier13216873crawlier
curlier93314183_curlier
dallier84215373_dallier
darklier1335013_darklier
dealer74122143dea_l_er
dearer74822803dear__er
dearie73319813dear_ie_
dearies83526273dear_ies
decrier102713553decr_ier
dernier83011943de_rnier
drawlier12225253drawlier
drearier9297923drear_ier
earliest82415243_earliest
earner63617223_ear_ner
earthier1137443_earthier
earthlier1244303_earthlier
easier64218463_ea_sier
eelier64216463_e_elier
eerier64320023_eer_ier
farrier103514893_farrier
fearer94820183fear__er
ferlie92814053fe_rlie_
ferlies103216693fe_rlies
fernier103110823fe_rnier
germier10309543ge_rmier
girlier8289523_girlier
gladlier1034343gladlier
glarier84112213glar_ier
hardier114721543_hardier
harrier104417753_harrier
haulier1059943_haulier
headier113212953hea_dier
headliner13135393headliner
healer94221803hea_l_er
hearer94323643hear__er
hearties11315413hearties
heathier1438343heathier
heavier13429423hea_vier
herbier1239593he_rbier
hoarier104211743hoar_ier
jerkier18407273je_rkier
knurlier1242883knurlier
lardier83518343_lardier
larkier113711523_larkier
leachier1337253leachier
leadier83212723lea_dier
leafier10329833lea_fier
leakier114010993lea_kier
learner7319383lear_ner
leavier10319993lea_vier
leerier73111503leer_ier
manlier92414023_manlier
marblier1256343_marblier
marrier93817523_marrier
mealie82519813mea_lie_
mealies92821933mea_lies
meatier93214613mea_tier
merrier92612303me_rrier
nearer64618893near__er
nearliest949363nearliest
nerdier83110353ne_rdier
nervier10298833ne_rvier
nettlier864813nettlier
pacier105018683p_a_cier
paler75436933p_a_l_er
palmer105816543p_a_lmer
palmier113312173p_almier
palter84423263p_a_lter
panier84425503p_a_nier
pannier93613353p_annier
pappier103511603p_appier
parader103914863p_arader
pardie96021443p_ardie_
pardner10239473p_ardner
parer75839903p_ar__er
paries84742513p_ar_ies
parker124121373p_ar_ker
parle75836163p_arl_e_
parled94626293p_arl_ed
parles86334403p_arl_es
parley116718363p_arl_ey
parleyer1335633p_arleyer
parling103823763p_arling
parlor8312673p_arl_or
parlour937263p_arlour
parried103615723p_arried
parriers103612903p_arriers
parries93925843p_arries
parser84822373p_ar_ser
parslied1137823p_arslied
partied103516553p_artied
partiers103514243p_artiers
parties93230863p_arties
partner92811393p_artner
partyer12337873p_artyer
pastier94320383p_astier
pawkier16236613p_awkier
peacher144216073pea_cher
peaklike13115373peaklike
pealed95322813pea_l_ed
pealike131211273pea_like
pealing104123203pea_ling
pearl75324463pearl___
pearlash1344133pearlash
pearlitic1345523pearlitic
pearls84715393pearl__s
pearly116414843pearl__y
peavies122213403pea_vies
peckier153910523pe_ckier
peculiar1245453peculiar
pedaler103410693pedal_er
pedalfer1443273pedalfer
pedaliers1245183pedaliers
pedaller1136093pedaller
peddler113210493peddl_er
pedler93614623pe_dl_er
peeler83517383pe_el_er
peerie83617893peer_ie_
peeries93623023peer_ies
pelter83321623pe__lter
penciler1237113penciler
peopler1138083peopl_er
peppier10268323pe_ppier
percher143313423pe_rcher
perdie94718513pe_rdie_
periled10316323pe_riled
perlite9317323pe_rlite
perlites10316363pe_rlites
perries93226603pe_rries
perter84422283pe_r_ter
peruser93511373pe_ruser
peskier13319113pe_skier
pestier94317403pe_stier
petrifier1447123petrifier
pettier94213613pe_ttier
pimplier1445413pimplier
plashier1337613plashier
platier93716293pla_tier
plier75221283p___lier
poachier1556823poachier
porkier133712343p_orkier
pornier93413133p_ornier
portlier1038373portlier
preachier1646923preachier
prealter1048863prea_lter
prier75027763p__r_ier
psalter9247813psa_lter
puddlier1234213puddlier
purlieu938143p_urlieu
pursier94012753p_ursier
purtier93214093p_urtier
quarrier1736843quarrier
quartier1737543quartier
rallier73816273_rallier
readier83117423rea_dier
realer63528593rea_l_er
realiser82512563rea_liser
realizer172412113rea_lizer
realter73716313rea_lter
rearer64928913rear__er
relier65826183re__lier
replier94214973re_plier
sallier73320423_sallier
sarkier113413313_sarkier
scalier94316913sca_lier
scarier94017873scar_ier
scarrier10298453scarrier
sealer63928963sea_l_er
seamier93114633sea_mier
searcher13209103searcher
searer65432023sear__er
seemlier1035193seemlier
shalier103116423sha_lier
smarmier1235033smarmier
smearier1036953smear_ier
snarkier12336513snarkier
snarler73610633snarl_er
sparkier14298033sparkier
sparklier1554363sparklier
sparrier10329143sparrier
spearer93913663spear__er
spearlike1544143spearlike
sprawlier1443293sprawlier
starrier8279463starrier
surlier72915443_surlier
swirlier1135213swirlier
tallier72817213_tallier
tardier859719993_tardier
tarrier74323173_tarrier
tarsier74119253_tarsier
tartier74123263_tartier
tearer64822903tear__er
terrier73414963te_rrier
treaclier1144153treaclier
twirlier1133513twirlier
varier94619353_var_ier
vealer94016543vea_l_er
verier94620963ve_r_ier
vernier102711273ve_rnier
warier93722893_war_ier
wartier103413913_wartier
wearer94319403wear__er
wearied112911803wear_ied
wearies103020223wear_ies
whirlier14175293whirlier
yearling1297883yearling
yearner10336873year_ner
yeastier1135393yeastier

Search took 9 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.436409841.7
2DLD Change Limit1461622697.48319532.5
3Display Results2692690.1102445.5
 (SQL Overall)1786912698.02922255.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.