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

149 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
travelers1226677(None) 
ravelers113310861_ravelers
traveler11328431traveler_
travellers1364661travellers
drivelers1364222drivelers
graveless13226692graveless
grovelers13305162grovelers
raveler104212462_raveler_
ravellers12257162_ravellers
raveners11309132_raveners
revelers113414132_revelers
teaselers9165852teaselers
traceless11228642traceless
trailers82912922tra_ilers
trammelers1442512trammelers
tramplers13305882tramplers
traveled12349452travele_d
traveller1266602traveller_
travelogs1343382travelogs
travels104711292travel__s
traversers13113302traversers
trawlers113310202tra_wlers
trowelers12105262trowelers
bevelers13389463_bevelers
brabblers12335563brabblers
bracelets1345963bracelets
braillers1135553braillers
brakeless1544993brakeless
braveness14237763braveness
bravers124715523brav__ers
brawlers13408643bra_wlers
cavilers1348113_cavilers
cradlers11309203cra_dlers
cravers124416563crav__ers
crawlers13309013cra_wlers
drawlers12307313dra_wlers
driveler1284693driveler_
drivellers1452953drivellers
enamelers1144803enamelers
frameless1435533frameless
frivolers1543473frivolers
grabblers14345513grabblers
graceless12226893graceless
gradeless11236703gradeless
grapplers14274303grapplers
grateless10277583grateless
graveled13417363gravele_d
gravels113611143gravel__s
graveness13288383graveness
gravers114515273grav__ers
groveler12305843groveler_
groveless13235363groveless
grovellers1443323grovellers
gruelers936173gr_uelers
labelers10249413_labelers
laveers10329363_lave_ers
levelers11259323_levelers
prattlers11195323prattlers
quaverers2143853quaverers
rabblers123810853_rabblers
rafflers14317363_rafflers
railers74420663_ra_ilers
ramblers124010373_ramblers
rattlers83510293_rattlers
ravagers1235583_ravagers
raveled114113633_ravele_d
ravelins113011603_ravelins
raveller11339263_raveller_
ravels94717073_ravel__s
ravener104110743_ravener_
ravers94628183_rav__ers
reelers73520273_r_eelers
revealers12318243_revealers
reveler104116343_reveler_
revellers12319513_revellers
reverers113113153_reverers
revilers114011693_revilers
riveters11228163_riveters
shovelers15174943shovelers
slaverers12165993slaverers
snivelers1264533snivelers
straddlers12203823straddlers
stragglers12305253stragglers
stranglers11396823stranglers
tacklers143010773t_acklers
tailers73720183t_a_ilers
talers64628143t_a__lers
tameless10259903t_ameless
tanglers92911973t_anglers
tapeless10218643t_apeless
taperers10269773t_aperers
tattlers8369693t_attlers
taverners1244273t_averners
teaseler8176583teaseler_
teasellers1043983teasellers
thalers106212263tha__lers
tracers94917843tra__cers
trachles13311753trachle_s
trackers143512853tra_ckers
trackless15246723trackless
traders84316953tra__ders
traducers1243723traducers
trailer73015393tra_iler_
trailless935963trailless
trainers83114643tra_iners
trameled11309073tramele_d
tramells10327833tramel_ls
tramels93812493tramel__s
tramless1037503tra_mless
trammeler1343223trammeler_
trampers123210393tra_mpers
trampler12278013trampler_
tramples122610203trample_s
transfers1238053transfers
trapeses1039153trapese_s
trapezes1936543trapeze_s
trappers123711043tra_ppers
trashers113013643tra_shers
travel94112983travel___
traveling1349053traveling
travelled1356863travelled
travelog1243513travel_og
traverse1136213trav__erse
traverser1244143traverser_
traverses1246343traverses
traves94222743trav__e_s
trawler104011903tra_wler_
trawleys14284383tra_wleys
treadlers1045893treadlers
treeless839283tr_eeless
tremblers1334483tremblers
triflers113110213tr_iflers
trillers83613493tr_illers
trimeters1139213trimeters
trollers83211213tr_ollers
troublers1135003troublers
trovers103713323trov__ers
troweler11106063troweler_
trowellers1343663trowellers
truceless11235393truceless
trucklers15295583trucklers
trundlers10215003trundlers
tunnelers953463tunnelers
twaddlers14343613twaddlers
twanglers1363433twanglers
waveless1437483_waveless
wavelets1436153_wavelets
waverers14318613_waverers
wranglers1344273wranglers

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.423422437.4
2DLD Change Limit1486411496.87321626.8
3Display Results1491490.0801862.5
 (SQL Overall)1786911497.37624226.0
 
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.