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 “droll” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

76 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
droll6541540(None) 
doll56632491d_oll
drill64718261drill
drolls75312391drolls
drolly105411671drolly
drool65416101drool
roll46331651_roll
troll54416531troll
atoll57913922atoll
bedroll1055552bedroll
boll65634752_boll
brill74819952brill
broil74918222broil
brolly114510852brolly
dell56938202d_ell
dhole95215362dhole
dill55239972d_ill
diol57329132dio_l
diols65521012diols
dol47150652d_o_l
dole56550002d_ole
dolls66126922d_olls
dolly96125202d_olly
dols56943052d_ols
dolt56649422d_olt
dooly94821802dooly
drail65020972drail
drawl95516012drawl
drills74414202drills
drily95816522drily
droid74218542droid
droit65127122droit
drolled93810222drolled
droller84110282droller
drone65324982drone
drools74412812drools
drooly104911072drooly
droop85814822droop
drop75324402dro_p
drops85719502drops
dropt86924432dropt
dross65418092dross
drouk1039432drouk
drove95518062drove
drown95515822drown
dryly12538452dryly
dull56430442d_ull
dwell9519852dwell
enroll61110072enroll
frill84917562frill
grill64617892grill
growl96115822growl
knoll9389602knoll
krill94213642krill
loll46128382_loll
moll66735702_moll
poll66332132_poll
prill74117942prill
prole74527792prole
prowl105615122prowl
quoll14379492quoll
reroll6412682reroll
rill45140902_rill
roil46235292_roil
role45851822_role
rolf75134872_rolf
rolls55326232_rolls
rotl45029682_rotl
scroll8310172scroll
stroll6311602stroll
toll45535262_toll
trill55122932trill
trolls64613942trolls
trolly94012362trolly
trull54012672trull
unroll61210072unroll

Search took 4 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 Filter178691538000.440406115.9
2DLD Change Limit53800762.56021015.6
3Display Results76760.0332303.0
 (SQL Overall)178691763.03358915.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.