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

179 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
pearliest113936(None) 
earliest82415241_earliest
nearliest949361nearliest
deadliest1138182deadliest
featliest1238362featliest
gnarliest10186552gnarliest
heartiest12311102heartiest
leariest83117852lear_iest
marliest102415182_marliest
mealiest102215972mea_liest
measliest1147172measliest
paliest93021612p_a_liest
palliest102814642p_alliest
peachiest1638532peachiest
peakiest143513002pea_kiest
pearlier1037322pearlie_r
pearlites1138232pearlites_
peartest10311302pear_test
peatiest103118812pea_tiest
pebbliest1543712pebbliest
perkiest143313242pe_rkiest
snarliest91810212snarliest
teariest82417262tear_iest
vealiest112513202vea_liest
weakliest1635852weakliest
weariest112914792wear_iest
yearlies1137602yearlies_
aeriest73924053ae_r_iest
artiest73121993__artiest
barkiest144115153_barkiest
barmiest125212783_barmiest
barniest104815053_barniest
beachiest1638453beachiest
beadiest113815533bea_diest
beakiest143313463bea_kiest
beamiest123212763bea_miest
beastliest1244663beastliest
beeriest104013403beer_iest
bleariest1158853blear_iest
brawliest14177193brawliest
burliest103113063_burliest
chariest13315513char_iest
charlies133414233charlies_
charriest1438263charriest
cleanliest1244363cleanliest
coaliest10316223coa_liest
crawliest14187403crawliest
curliest102713123_curliest
darkliest1435163_darkliest
dearest83618673dear__est
dearies83526273dear_ies_
drawliest13166243drawliest
dreariest10229123drear_iest
earless74316073_earl_ess
earlier72612743_earlie_r
earliness939693_earliness
earnest7318733_ear_nest
earthiest1259113_earthiest
earthliest1345403_earthliest
easiest72318773_ea_siest
eeliest73516473_e_eliest
eeriest73620673_eer_iest
fearless1137873fearl_ess
ferlies103216693fe_rlies_
ferniest1132214153fe_rniest
gearless937373gearl_ess
germiest11249923ge_rmiest
girliest93010403_girliest
gladliest1135383gladliest
glariest92012533glar_iest
hardiest123416343_hardiest
headiest123015553hea_diest
hearties11315413hearties_
heathiest1549393heathiest
heaviest143210443hea_viest
herbiest1339993he_rbiest
hoariest11312883hoar_iest
jerkiest19328113je_rkiest
knurliest1344073knurliest
lardiest93813893_lardiest
larkiest123713323_larkiest
leachiest1437253leachiest
leadiest93314993lea_diest
leafiest113410893lea_fiest
leakiest123212803lea_kiest
leaviest112910823lea_viest
leeriest83112883leer_iest
manliest102314943_manliest
marbliest1336763_marbliest
mealies92821933mea_lies_
meatiest102816793mea_tiest
merriest10311483me_rriest
nearest73415843near__est
nearlier836803nearlie_r
nerdiest92511163ne_rdiest
nerviest11188833ne_rviest
nettliest945413nettliest
paciest112917813p_a_ciest
palest83926223p_a_l_est
palmiest123212033p_almiest
pappiest112611123p_appiest
paries84742513p_ar_ies_
parles86334403p_arl_es_
parries93925843p_arries_
parties93230863p_arties_
pastiest103319553p_astiest
pawkiest17277893p_awkiest
peakless14236683peakl_ess
pearlash1344133pearl_ash
pearled10411553pearl_e_d
pearler9310373pearl_e_r
pearlers1039033pearl_ers
pearling11912013pearli_ng
pearlite1039443pearli_te
pearlitic1345523pearlitic
pearlized2145563pearlized
pearls84715393pearl__s_
peartness1137773peartness
peavies122213403pea_vies_
peckiest162711393pe_ckiest
peeries93623023peer_ies_
peerless1037513peerl_ess
peppiest11278573pe_ppiest
perlites10316363pe_rlites_
perries93226603pe_rries_
persist9315853pe_rsi_st
pertest9317043pe_r_test
peskiest142610163pe_skiest
pestiest103018413pe_stiest
pettiest103113963pe_ttiest
phallist1338993phalli_st
pimpliest1545483pimpliest
plashiest1478383plashiest
platiest103216093pla_tiest
playlist1347573playli_st
poachiest1636893poachiest
porkiest143513713p_orkiest
porniest103214313p_orniest
portliest11310183portliest
preachiest1746983preachiest
priest84125423p__r_iest
puddliest1343693puddliest
pursiest102812123p_ursiest
purtiest102414113p_urtiest
readiest93719043rea_diest
realest73322433rea_l_est
realist73225383rea_li_st
rearrest8311603rear_rest
sarkiest123615073_sarkiest
scaliest101714403sca_liest
scariest101615953scar_iest
scarriest11188403scarriest
seamiest102715423sea_miest
searest73322023sear__est
seemliest1145623seemliest
shaliest111415063sha_liest
smarmiest1335913smarmiest
smeariest1138123smear_iest
snarkiest13207643snarkiest
sparkiest15188103sparkiest
sparkliest1644583sparkliest
sparriest11198793sparriest
sprawliest1543583sprawliest
starriest9159773starriest
surliest82416913_surliest
swirliest1236293swirliest
tardiest93515243_tardiest
tarriest83215003_tarriest
tartiest82718313_tartiest
tearless848713tearl_ess
treacliest1245383treacliest
twirliest1234503twirliest
veriest103719133ve_r_iest
wariest105122503_war_iest
wartiest113614643_wartiest
wearies103020223wear_ies_
weariless1234763weariless
whirliest15216043whirliest
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 Filter1786911486410.440406115.9
2DLD Change Limit1486411798.14018260.6
3Display Results1791790.0762355.3
 (SQL Overall)1786911798.65620643.6
 
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.