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

152 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
nearliest94936(None) 
earliest82415241_earliest
pearliest1139361pearliest
deadliest1138182deadliest
featliest1238362featliest
gnarliest10186552gnarliest
heartiest12311102heartiest
leariest83117852lear_iest
marliest102415182_marliest
mealiest102215972mea_liest
measliest1147172measliest
nearest73415842near__est
nearlier836792nearlie_r
nerdiest92511162ne_rdiest
nerviest11188832ne_rviest
nettliest945412nettliest
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
naggiest102610013n_aggiest
nappiest122510893n_appiest
narcist9512443n_arci_st
nastiest83615953n_astiest
nattiest83215353n_attiest
nearness838313near_ness
nearsides1044513nearsides_
neatest72516003nea__test
neediest92611303ne_ediest
nellies73418723ne_llies_
nettiest83112433ne_ttiest
newsiest11107483ne_wsiest
niggliest1144933niggliest
nubbliest1354363nubbliest
oneriest8313443one_r_iest
paliest93021613_pa_liest
palliest102814643_palliest
peachiest1638533peachiest
peakiest143513003pea_kiest
pearlier1037323pearlie_r
pearlites1138233pearlites_
peartest10311303pear_test
peatiest103118813pea_tiest
pebbliest1543713pebbliest
perkiest143313243pe_rkiest
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
sneakiest13176843snea_kiest
sneeriest939313sneer_iest
sparkiest15188103sparkiest
sparkliest1644583sparkliest
sparriest11198793sparriest
starriest9159773starriest
surliest82416913_surliest
swirliest1236293swirliest
tardiest93515243_tardiest
tarriest83215003_tarriest
tartiest82718313_tartiest
tearless848713tearl_ess
treacliest1245383treacliest
twirliest1234503twirliest
unearthliest1552383unearthliest
uneasiest946563unea_siest
unmanliest1244483unmanliest
unwariest1246033unwar_iest
veriest103719133ve_r_iest
wariest105122503_war_iest
wartiest113614643_wartiest
wearies103020223wear_ies_
weariless1234763weariless
whirliest15216043whirliest
yeastiest1237203yeastiest

Search took 8 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.423422437.4
2DLD Change Limit1486411526.56322648.3
3Display Results1521520.0632412.7
 (SQL Overall)1786911527.04925349.8
 
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.