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

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

93 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
drivelled144398(None) 
driveled1374971drive_led
driveller1353851driveller
bedrivelled1871402bedrivelled
drilled94711672dri__lled
driveler1284692drive_ler
drivellers1452952drivellers
frivolled1642382frivolled
gravelled1475552gravelled
grovelled1454182grovelled
ravelled12419782_ravelled
revelled123712742_revelled
rivalled1236092_rivalled
shrivelled1742372shrivelled
snivelled1353992snivelled
swivelled1662962swivelled
travelled1356862travelled
bedriveled1761713bedrive_led
bevelled14327823_bevelled
chiselled1544223chiselled
crenelled1245403crenelled
defuelled1443133defuelled
develed123611933d_eve_led
devilled1336743d_evilled
dialled9510133d_i_alled
dilled84122223d_i__lled
dispelled13117573dispelled
diverged14256883d_iverged
diverted13199583d_iverted
divested13268213d_ivested
divulged1442963d_ivulged
divulsed1343883d_ivulsed
dowelled1356343d_owelled
dribbled14376593dri_bbled
driller84311883dri__ller
drivable1438023drivable_
driveable1544523driveable_
drivel105110383drive_l__
drivelers1364223drivelers
driveline1345353driveline
drivelines1444593drivelines
driveling1445763driveling
drivelling1543983drivelling
drivels11397923drive_l_s
driverless1452703driverless
drizzled18284573dri_zzled
drolled93810223dr__olled
drywalled1741833drywalled
duelled9359753d__uelled
dwelled12337593d__welled
frilled113911603fri__lled
frivoled1534043friv_oled
frivoller1542433frivoller
gavelled13387363_gavelled
graveled13417363grave_led
grilled94012833gri__lled
groveled13345453grove_led
groveller1354233groveller
gruelled1034893gr_uelled
hirselled1344693hirselled
hovelled15146843_hovelled
kvelled15276063__kvelled
levelled12327453_levelled
libelled11317213_libelled
marvelled1544963marvelled
prilled104713003pri__lled
propelled1456913propelled
raveled114113633_rave_led
raveller11339263_raveller
rebelled113110333_rebelled
refelled122810173_refelled
repelled113111593_repelled
revealed123211213_revealed
reveled113917753_reve_led
reveller112912193_reveller
rilled74525653_ri__lled
rivaled1138933_riv_aled
riverbed14245143_riverbed
riveted11258573_rive_ted
rivetted12226093_rivetted
rowelled1236633_rowelled
shovelled16174413shovelled
shriveled1643153shrive_led
sniveled1255463snive_led
sniveller1253703sniveller
swiveled1544163swive_led
tramelled1266223tramelled
traveled12349453trave_led
traveller1266603traveller
trilled84116313tri__lled
trowelled1344443trowelled
unravelled1443863unravelled
unrivalled1443243unrivalled

Search took 7 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.436409841.7
2DLD Change Limit148641936.42323142.0
3Display Results93930.0303100.0
 (SQL Overall)178691936.88925938.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.