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

110 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
travelled135686(None) 
gravelled1475551gravelled
ravelled12419781_ravelled
tramelled1266221tramelled
traveled12349451trave_led
traveller1266601traveller
drivelled1443982drivelled
gavelled13387362_gavelled
graveled13417362grave_led
grovelled1454182grovelled
marvelled1544962marvelled
raveled114113632_rave_led
raveller11339262_raveller
revelled123712732_revelled
teaselled1045122teaselled
teazelled1943732teazelled
trameled11309072trame_led
trammelled1542222trammelled
travailed1344222travailed
traveler11328432trave_ler
travellers1364662travellers
traversed1344562traversed
trowelled1344442trowelled
unravelled1443862unravelled
barrelled1245253barrelled
bevelled14327793_bevelled
brailled1147193bra_illed
caravelle1444693caravelle_
caravelles1544883caravelles
cavilled1436733_cavilled
cravened1476713crave_ned
crenelled1245403crenelled
driveled1374973drive_led
driveller1353853driveller
enamelled1244613enamelled
frivolled1642383frivolled
gabelled12317583_gabelled
gaveled12399133_gave_led
gravelly15385773gravell_y
groveled13345453grove_led
groveller1354233groveller
gruelled1034893gr_uelled
hovelled15146843_hovelled
kvelled15276063__kvelled
labelled11278293_labelled
lapelled11227083_lapelled
levelled12327443_levelled
marcelled1445203marcelled
marveled1436433marve_led
outtravelled1651323outtravelled
panelled1138963_panelled
parcelled1445773parcelled
propelled1456903propelled
rappelled1443703_rappelled
raveler104212463_rave_ler
ravellers12257163_ravellers
ravelly13268353_ravell_y
ravened115012283_rave_ned
rebelled113110323_rebelled
refelled122810163_refelled
repelled113111573_repelled
revealed123211213_revealed
reveled113917753_reve_led
reveller112912183_reveller
rivalled1236093_rivalled
rowelled1236633_rowelled
shovelled16174413shovelled
shrivelled1742373shrivelled
snivelled1353993snivelled
swivelled1662963swivelled
tasselled1044633tasselled
teaseled9186793tease_led
teaseller945193teaseller
teazeled18194233teaze_led
thralled1245803thra__lled
tinselled1044413tinselled
towelled1236353t_owelled
trabeated1246843trabeated
traceried1247143traceried
trachled1438313tra_chled
trailed83415673tra__iled
trailered1045393trailered
trajected1944043trajected
tramell9398703tramell__
tramells10327833tramell_s
trammeled1453203trammeled
trampled13247903tra_mpled
trapesed1136473trape_sed
trauchled1543733trauchled
travel94112983trave_l__
travelers12266773travelers
traveling1349053traveling
travelling1456533travelling
travelog1243513trave_log
travelogs1343383travelogs
travels104711293trave_l_s
traverse1136213traverse_
traverser1244133traverser
traverses1246343traverses
travestied1443833travestied
trawled113411523tra__wled
trebled1038483tr__ebled
trilled84116313tr__illed
trolled84312263tr__olled
troweled12106113trowe_led
troweller1244563troweller
tunnelled1054583tunnelled
unraveled1345543unrave_led
untraveled1444403untrave_led
weaselled1344183weaselled

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.1731032896.0
2DLD Change Limit1486411106.79621871.8
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.01525472.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.