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

138 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
drollest93735(None) 
drolled93810222drolle_d
droller84110282drolle_r
drollery12314792drollery
drollness1043622drollness
drolls75312392droll_s_
drooliest1036342drooliest
droplet10312112drople_t
droplets1136062droplets
dullest8312632d_ullest
adroitest1044763adroitest
arbalest1039523arbalest
arbelest1049503arbelest
boldest102613063_boldest
broadest1138573broadest
brollies1039533brollies_
browless1346653browless
brownest1398893brownest
chillest13259593chillest
coldest102514763_coldest
collect113314593_collect
collet84030363_colle_t
collets93517903_collets
coolest9318643_coolest
crookest1436683crookest
cropless1237793cropless
crossest1012012123crossest
cruelest1059183cruelest
cruellest1155583cruellest
dalles74222063d_alles_
darkliest1435163darkliest
dholes104914793dho_les_
diallist949553diallist
doest65829523d_o__est
doles67843753d_o_les_
dolled83518073d_olle_d
dollies83620983d_ollies_
dollish11610093d_ollish
dolls66126923d_oll_s_
doodles93614163doodles_
doolees83711613doolees_
doolies83920713doolies_
doomiest112910453doomiest
doorless936713doorless
dopiest103315993d_opiest
dorkiest133111253dorkiest
dotiest83717453d_otiest
dourest8312943d_ourest
doziest174012473d_oziest
drabbest13295663drabbest
drawliest13166243drawliest
drest65530343dr___est
driblet103712243drible_t
driblets11266093driblets
driest74722753dr__iest
drilled94711673drille_d
driller84311883drille_r
drillers9429723drillers
drills74414203drill_s_
dripless1135243dripless
drogues9398393drogues_
droll65415403droll___
drolling103510763drolling
drolly105411673droll__y
drones75023433dro_nes_
drooled9369203droole_d
drools74412813drool_s_
droopiest1235743droopiest
drosses84513823drosses_
drossiest1036523drossiest
droves105116673dro_ves_
drowses114610233drowses_
drowsiest1334993drowsiest
drumliest1235433drumliest
drunkest1334423drunkest
dryest104811123dr__yest
duellist986333duellist
evillest1146353evillest
fellest10313753_fellest
folles93820473_folles_
foulest10313313_foulest
frailest1139493frailest
frilliest1237113frilliest
froglet11310063frogle_t
froglets1235263froglets
fullest10313343_fullest
girolles935523girolles_
goldest92411173_goldest
grilles83715023grilles_
grodiest10310553grodiest
grossest93810093grossest
growliest1335583growliest
holiest104319623_holiest
illest63615723__illest
jolliest152910363_jolliest
molest85022743_mo_lest
noblest93613563_noblest
oldest72114093__oldest
pollist9816603_pollist
proles84627203pro_les_
prosiest10416523prosiest
protest9317533pro_test
proudest1138943proudest
prowest12311533pro_west
realest73322433_realest
rilles64725503_rilles_
rillet64828853_rille_t
rillets74216153_rillets
robles85321693_robles_
rodless8310073_rodless
roiliest8312283_roiliest
roles56747983_ro_les_
rolled74220243_rolle_d
roller63919793_rolle_r
rollers73117473_rollers
rollout7811943_rollout
rolls55326233_roll_s_
ropiest93317773_ropiest
rosiest73919213_rosiest
ruliest72816433_ruliest
shoalest1168913shoalest
shrillest1245393shrillest
smallest1039403smallest
snellest839493snellest
stillest8311073stillest
swellest1137663swellest
tallest7317093_tallest
toolless836343toolless
trolled84312263trolle_d
troller73913173trolle_r
trollers83211213trollers
trolley10328753trolle_y
trolleys11315693trolleys
trollies8310233trollies_
trolls64613943troll_s_
wooliest113011643wooliest
woolliest1235853woolliest
wrongest1236733wrongest

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.1561145455.1
2DLD Change Limit1461621388.12617987.0
3Display Results1381380.0632190.5
 (SQL Overall)1786911388.34521412.9
 
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.