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

232 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
peartest1031130(None) 
pertest9317041pe_rtest
dearest83618672dear_est
earnest7318732_earnest
featest102715112fea_test
heartiest12311102heartiest
leariest83117842leariest
nearest73415842near_est
neatest72516002nea_test
peakiest143512992peakiest
pearliest1139352pearliest
pearter9412742pearte_r
peartness1137772peartness
peatiest103118802peatiest
phattest1336912phattest
rearrest8311602rearrest
searest73322022sear_est
smartest10310182smartest
tartest72517532_tartest
teariest82417262teariest
weariest112914792weariest
aerates74627493aerates_
aeriest73924053ae_riest
alertest8310173alertest
aptest82917513__aptest
arrest63722633__arrest
artiest73121993__artiest
artist64125543__artist
attest62618613__attest
barest85327693_bar_est
beadiest113815533beadiest
beakiest143313463beakiest
beamiest123212763beamiest
beeriest104013403beeriest
berates94126873berates_
bleariest1158843bleariest
cartes86239473_cartes_
cerates95428253cerates_
certes84623083ce_rtes_
chariest13315503chariest
chartist131112133chartist
chastest1349703chastest
clearest1038653clear_est
coarsest1039163coarsest
coattest1038863coattest
curtest9713963_curtest
daftest11248943_daftest
darkest122512623_darkest
deadest93014883dea_dest
deafest112911513dea_fest
dearies83526273dearies_
dearness939973dearness
dearths11498843dearths_
deftest112611713de_ftest
derates84028893derates_
detest74122843de__test
dreariest10229123dreariest
dwarfest1543473dwarfest
earless74316073_earless
earliest82415243_earliest
earnests837853_earnests
earthiest1259103_earthiest
earths95014593_earths_
earthset11410823_earthset
easiest72318773_easiest
ecartes94212563ecartes_
eeriest73620673_eeriest
exactest1745453exactest
farthest1499863_farthest
fastest102413723_fastest
fattest102913063_fattest
fearless1137873fearless
flattest1138713flattest
gearless937373gearless
glariest92012523glariest
greatest939863grea_test
hardest113118413_hardest
harvest132112753_harvest
headiest123015553headiest
headrest122910203headrest
hearses104414533hearses_
heartbeat1444633heartbeat
hearted113314023hearte_d
hearten102411753hearte_n
heartens113010153heartens
heartfelt1543263heartfelt
hearths135311073hearths_
hearties11315413hearties_
heartless1236393heartless
hearts96218943heart_s_
heaviest143210443heaviest
hoariest11312883hoariest
hoarsest1137133hoarsest
iratest7312483ira_test
largest83715103_largest
latest63822703_la_test
leadiest93314983leadiest
leafiest113410883leafiest
leakiest123212793leakiest
leanest7415863lea_nest
leaviest112910813leaviest
leeriest83112883leeriest
leftest10269463le_ftest
mealiest102215973mealiest
meanest9315703mea_nest
meatiest102816793meatiest
merest84725113me_r_est
merriest10311473merriest
nearliest949363nearliest
nearness838313nearness
operates10515413operates_
paciest112917803p_aciest
palest83926223p_a_lest
paliest93021603p_aliest
parent83230423p_ar_ent
pares77164483p_ar_es_
parges94529543p_arges_
parget94529393p_arge_t
pargets105215193p_argets
paries84742513p_aries_
parles86334403p_arles_
parses85534703p_arses_
parted94228683p_arte_d
parties93230863p_arties_
partlet92720363p_artlet
partlets102811513p_artlets
parts77743373p_art_s_
pastes85233913p_astes_
pastiest103319543p_astiest
patent84524923p_a_tent
pates76047893p_a_tes_
peaces106324083pea_ces_
peaches144120053peaches_
peachiest1638523peachiest
peages94321843pea_ges_
peakless14236683peakless
pearlash1344133pearlash
pearled10411543pearle_d
pearler9310373pearle_r
pearlers1039033pearlers
pearlites1138233pearlites_
pearls84715393pear_ls_
pears75138613pear__s_
peart76440753pear___t
peartly1267453peart_ly
peases85229473pea_ses_
peats76140193pea_t_s_
peavies122213403peavies_
peckiest162711393peckiest
peeress939503peer_ess
peeries93623023peeries_
peerless1037513peerless
pelites93821993pelites_
peltast9310513pe_ltast
penates93321593penates_
penitent10413503penitent
peppiest11278563peppiest
percent113520603pe_rcent
percept133112523pe_rcept
peres76246643pe_r_es_
perfect141010833pe_rfect
perkiest143313243perkiest
perpent112318803pe_rpent
perries93226603perries_
perses85428063pe_rses_
persist9315853pe_rsist
perter84422283pe_rte_r
pertness10310093pe_rtness
pervert12315583pe_rvert
peskiest142610163peskiest
pestiest103018413pestiest
petites93820203petites_
pettiest103113963pettiest
peyotes1238483peyotes_
phantast1346923phantast
pirates93020333pirates_
plainest10313613plainest
plates85432243pla_tes_
platiest103216083platiest
politest10312943politest
poorest9312773poor_est
portent93619643p_ortent
posttest10410233posttest
prates84633163pra_tes_
preharvest1883363preharvest
prest75736353p__r_est
pretest9517633p_retest
priest84125423p__riest
protest9317533p_rotest
purest84021933p_ur_est
purtiest102414113p_urtiest
quartes163314933quartes_
quartet162814893quarte_t
quartets17277573quartets
rarest65725483_rar_est
readiest93719043readiest
realest73322433rea_lest
rearmost1047263rearmost
rearrests945313rearrests
remotest103310723remotest
retest64028453re__test
saltest71916513_saltest
scantest101710183scantest
scarcest12169173scarcest
scariest101615943scariest
seamiest102715413seamiest
secretest1147033secretest
sedatest9249393sedatest
serest64831613se_r_est
sharpest1339143sharpest
shortest11310783shortest
smeariest1138113smeariest
sparest94616423spar_est
sparsest1048813sparsest
starkest1239723starkest
tartiest82718313_tartiest
tautest72612443_tautest
tearless848713tearless
tersest71713993te_rsest
vastest102911513_vastest
vealiest112513203vealiest
veriest103719133ve_riest
wariest105122503_wariest
warmest123113033_warmest
wartiest113614643_wartiest
wattest102412153_wattest
weakest1439003wea_kest
wearies103020223wearies_
weirdest1244433weirdest
wettest10239363we_ttest
yarest95018913_yar_est
yeastiest1237203yeastiest

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.1731032896.0
2DLD Change Limit1461622328.20317818.1
3Display Results2322320.0932494.6
 (SQL Overall)1786912328.46921099.4
 
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.