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

113 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
drivelers136422(None) 
driveler1284691driveler_
drivellers1452951drivellers
dribblers14274452dribblers
drillers9429722dri_llers
driveled1374972drivele_d
driveller1353852driveller_
drivels11397922drivel__s
driverless1452702driverless
drivers114412792driv__ers
frivolers1543472frivolers
grovelers13305162grovelers
ravelers113310862_ravelers
revelers113414132_revelers
riveters11228162_riveters
snivelers1264532snivelers
travelers12266772travelers
bevelers13389453_bevelers
bridlers11359183bri_dlers
briefers1335143bri_efers
brineless1136243brineless
chiselers1445453chiselers
crimeless1335063crimeless
cripplers15314993cripplers
deliverers1443663deliverers
derivers123811363deriv__ers
dialers83614303d_i_alers
diallers957773d_iallers
dibblers13377583d_ibblers
diddlers11359153d_iddlers
dieters83216433d_i_eters
dimeters11411093d_imeters
divers105024963d_iv__ers
diverters13227873d_iverters
dividers13257213d_ividers
diviners12308353d_iviners
divulgers1442433d_ivulgers
drawlers12307313dr_awlers
dribbler13316313dribbler_
dribbles13348393dribble_s
dribblets14294143dribblets
driblets11266093dri_blets
driers74516733dri___ers
drifters12417913dri_fters
driller84311883dri_ller_
drinkers13277823dri_nkers
dripless1135243dri_pless
drippers13327943dri_ppers
drivel105110383drivel___
driveline1345353driveline
drivelines1444593drivelines
driveling1445763driveling
drivelled1443983drivelled
drivenness1443463drivenness
driver104714493driv__er_
drives105117113driv__e_s
driveways1941813driveways
drizzles17295293drizzle_s
drovers115212643drov__ers
drupelets1242683drupelets
duelers83412053d__uelers
fribblers16314193fribblers
frillers11349873fri_llers
frivoler1443933frivoler_
frivollers1642073frivollers
frizzlers20293673frizzlers
graveless13226693graveless
grievers1255473gri_evers
grillers93810813gri_llers
grizzlers18253233grizzlers
groveler12305843groveler_
groveless13235363groveless
grovellers1443323grovellers
gruelers936173gr_uelers
hiveless14227933_hiveless
levelers11259323_levelers
libelers10238623_libelers
liveners11217933_liveners
priceless1336883priceless
quiverers2143713quiverers
raveler104212463_raveler_
ravellers12257163_ravellers
raveners11309133_raveners
reelers73520273_r_eelers
revealers12318243_revealers
reveler104116343_reveler_
revellers12319503_revellers
reverers113113153_reverers
revilers114011693_revilers
riddlers10269103_riddlers
rievers104311453_ri_evers
rifflers14336443_rifflers
riflers103512193_ri_flers
ripeners1036833_ripeners
ripplers12337113_ripplers
riverless1244943_riverless
rivers94626543_riv__ers
riveter10208753_riveter_
rivulets1174753_rivulets
scriveners1543143scriveners
shiverers15155773shiverers
shovelers15174943shovelers
sliverers12196363sliverers
sniveler1155253sniveler_
snivellers1352873snivellers
spielers10319653spi_elers
traveler11328433traveler_
travellers1364663travellers
triflers113110213tri_flers
trillers83613493tri_llers
trimeters1139213trimeters
trowelers12105263trowelers
wrigglers14273713wrigglers

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.420425454.8
2DLD Change Limit1486411137.12620859.0
3Display Results1131130.0462456.5
 (SQL Overall)1786911137.59223536.7
 
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.