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

525 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
travels10471129(None) 
gravels113611141gravels
ravels94717071_ravels
tramels93812491tramels
travel94112981travel_
traves94222741trave_s
bravely15428232bravely
bravers124715522bravers
braves115524082brave_s
caravels1337432caravels
carvels124914592carvels
cravens124010112cravens
cravers124416542cravers
craves115825392crave_s
drivels11397922drivels
gavels105911092_gavels
gravel105313822gravel_
gravely14469062gravely
gravers114515262gravers
graves104624002grave_s
grovels11427812grovels
marvels123810092marvels
navels95712692_navels
ratels64518212_ratels
ravel84621512_ravel_
ravens93916882_ravens
ravers94628182_ravers
raves85441972_rave_s
revels94220572_revels
taels56822072t_a_els
teasels74311312teasels
teazels16406882teazels
thraves13469712thrave_s
tracers94917832tracers
traces85329932trace_s
traders84316942traders
trades75724492trade_s
trails64622512tra_ils
tramel84113712tramel_
tramell9398702tramell
tramells10327832tramells
trammels12295412trammels
trapes85024462trape_s
travails1146082travails
trave85223032trave__
traveled12349452traveled
traveler11328432traveler
travelers12266772travelers
travelog1243512travelog
travelogs1343382travelogs
traverse1136212traverse
travois1037872travois
trawls94412392tra_wls
trevets10499972trevets
trivets103911582trivets
trovers103713312trovers
troves94719112trove_s
trowels10358362trowels
unravels1144632unravels
agaves104611513agave_s
arables91814973arables
arames84622573arame_s
ariels65119373ar_iels
artels66216233ar_tels
avens86419333__avens
avers85127313__avers
aves76142603__ave_s
axels126313633__axels
babels105216723_babels
bagels95712313_bagels
barbels114514433barbels
barrels94514363barrels
beavers124417323beavers
bevels113913983_bevels
boatels93510233boatels
bracers114616703bracers
braces108427773brace_s
braes75735053bra_e_s
brails84621293bra_ils
brakes124923123brake_s
braless92910563braless
brasils9410973brasils
bravas114913323brav_as
brave104925503brave__
braved124817443brave_d
braver114719043brave_r
bravery15428133bravery
bravest124211753bravest
bravoes12418533bravoes
bravos114711393brav_os
brawls115214333bra_wls
brayers124511903brayers
brazens18418713brazens
brazers184513943brazers
brazes175522193braze_s
brazils1867753brazils
breves115516423breve_s
brevets12519393brevets
camels105217083_camels
caramels1238803caramels
caravel1238203caravel_
carcels114516063carcels
carpels115315463carpels
carrels95117303carrels
cartels94618123cartels
carvel114817573carvel_
carvers124817533carvers
carves115128453carve_s
cavers115026833_cavers
caves105639703_cave_s
cavils114014393_cavils
chapels14429153chapels
clavers124314893clavers
claves115020063clave_s
craals84113303cra_als
cradles103114133cradles
crakes124921813crake_s
cranes84330753crane_s
crapes104727693crape_s
crases85532313crase_s
craters95021883craters
crates85736053crate_s
cravats1237393cravats
crave105626313crave__
craved125417773crave_d
craven114113933crave_n
cravenly1644663cravenly
craver114618463crave_r
crawls114712083cra_wls
crazes174720133craze_s
creels84416943cr_eels
crenels93711013crenels
crewels12438483crewels
darnels83710433darnels
davens104612913_davens
deaves105319533deave_s
devels104313903_devels
dragees9359483dragees
drails74716953dra_ils
drakes114715863drake_s
drapers105313353drapers
drapes95419653drape_s
drave95219273drave__
drawees11378363drawees
drawers113610073drawers
drawls105511393dra_wls
drivel105110383drivel_
drivers114412793drivers
drives105117113drive_s
drovers115212643drovers
droves105116673drove_s
easels65914553_easels
eaves85231993_eave_s
enamels9128163enamels
erasers74413943erasers
erases64425403erase_s
ervils948773er_vils
fardels11389893fardels
farfels13348213farfels
favela1237033_favela
favelas1337023_favelas
faves115331423_fave_s
frails93716473fra_ils
framers125113823framers
frames115119863frame_s
fraters103517203fraters
frazils1956123frazils
frivols1334743frivols
garveys14124463garveys
gavel95815183_gavel_
graals74112913gra_als
grabens10367003grabens
graces94523493grace_s
graders94715993graders
grades84926313grade_s
grails77518783gra_ils
grapes95123123grape_s
grapnels1134393grapnels
graters85419733graters
grates75429883grate_s
graupels1133103graupels
grave94624873grave__
graved114818813grave_d
graveled13417363graveled
graveless13226693graveless
gravelly15385773gravelly
graven104513523grave_n
graver105018593grave_r
gravest114011633gravest
gravies11314093gravies
grazers175112443grazers
grazes164519643graze_s
greaves113311443greave_s
grivets11357973grivets
grovel104310543grovel_
groves104318103grove_s
gruels73910153gr_uels
havens124514043_havens
havers124721483_havers
haves116034873_have_s
hazels185710083_hazels
heavens13439303heavens
heavers133717193heavers
heaves124120303heave_s
hovels125413333_hovels
irades74517393irade_s
irately1047683irately
jarveys20123413jarveys
kevels134410713_kevels
knaves13439523knave_s
knawels14344683knawels
kraals10378433kra_als
krakens1034293krakens
kraters114212333kraters
labels84515683_labels
lapels83712043_lapels
lavers94526363_lavers
laves86039153_lave_s
leavens10409303leavens
leavers103717783leavers
leaves94222383leave_s
levels94113283_levels
loaves94813853loave_s
marcels113212373marcels
marvel113712003marvel_
mavens114312973_mavens
navel87016573_navel_
naves87030383_nave_s
novels95512503_novels
oaves84925613_oave_s
oracles93212423oracles
orals55826483ora__ls
orates64328613orate_s
oriels64914623or_iels
outraves112313833outrave_s
outtravels1352113outtravels
panels84716523_panels
parcels113712663parcels
parrels94713493parrels
pavers115021823_pavers
paves104833923_pave_s
peaveys15324063peaveys
prases84429023prase_s
praters94921643praters
prates84633163prate_s
praxes156215183praxe_s
prayers124212853prayers
preavers13910263preavers
privets122910053privets
propels113412843propels
provers123817793provers
proves114322253prove_s
quavers19309003quavers
racers84725433_racers
races74943243_race_s
ragees74618663_ragees
rages64539443_rage_s
rails55937403_ra_ils
rajes125022783_raje_s
rakees104516973_rakees
rakers104123573_rakers
rakes94440353_rake_s
rales54947493_rale_s
ramees84620893_ramees
ramets83517393_ramets
ranees64623963_ranees
rapers84327183_rapers
rapes75740723_rape_s
rappels11448803_rappels
rarely93513653_rarely
rares55247443_rare_s
rasers64526783_rasers
rases55447213_rase_s
ratals64219583_ratals
ratel54224883_ratel_
raters63936573_raters
rates55352013_rate_s
rave75542093_rave__
raved94931433_rave_d
raveled114113633_raveled
raveler104212463_raveler
ravelers113310863_ravelers
ravelin102211023_ravelin
ravelins113011603_ravelins
ravelly13268353_ravelly
raven84723443_rave_n
raver85631493_rave_r
ravins94622563_ravins
raxes124729393_raxe_s
razees154314763_razees
razers154919613_razers
razes145032703_raze_s
reavers108320743reavers
reaves94127573reave_s
rebels84518133_rebels
reels55333263_r_eels
refels94618053_refels
repels84318763_repels
reveals103812723_reveals
revel84423163_revel_
revers94529633_revers
revets94022173_revets
riels55121333_r_iels
rivals94213183_rivals
rivers94626543_rivers
rives85336003_rive_s
rivets94417113_rivets
rovers95423523_rovers
roves84834483_rove_s
rowels94515453_rowels
rubels84112993_rubels
savers93825923_savers
saves85838633_save_s
shavers134115093shavers
shaves125224933shave_s
shovels13378383shovels
shrivels14376443shrivels
slavers103716503slavers
slaves95023023slave_s
slaveys13415203slaveys
snivels10336903snivels
soaves94218673soave_s
starvers11459643starvers
starves104614553starve_s
staves94525193stave_s
strafers11379903strafers
strafes104515993strafe_s
strakes114218073strake_s
strayers113510133strayers
streels73811343str_eels
strivers113911843strivers
strives104119373strive_s
strudels934123strudels
suavely1376483suavely
swivels13396773swivels
tabers84621573t_abers
tabes76033923t_abe_s
tables84524883t_ables
taces76237803t_ace_s
tael46030713t_a_el_
tails55634193t_a_ils
tajes124920693t_aje_s
takers103923743t_akers
takes94437793t_ake_s
talers64628143t_alers
tales55451373t_ale_s
talls55133433t_a_lls
tamals84116623t_amals
tamely113711953t_amely
tamers84224033t_amers
tames75242013t_ame_s
tapers84025813t_apers
tapes75838603t_ape_s
tares57456563t_are_s
targes74524593targe_s
targets84314223targets
tarres64723043tarre_s
tarsals72512603tarsals
tassels74510853tassels
taters64932193t_aters
tates55444983t_ate_s
tavern9428933t_avern
taverns10317803t_averns
tavs75630973t_av__s
tawers94118603t_awers
taxers134015283t_axers
taxes124730823t_axe_s
taxols13328633t_axols
teals56234133tea__ls
tearers75218233tearers
teasel63914983teasel_
teasers75317243teasers
teases65426273tease_s
teazel15368543teazel_
teazles16308913teazles
teels55726373t__eels
tels46841693t___els
tercels94110363tercels
thalers106212263thalers
thanes94918983thane_s
thawers13428483thawers
thralls10299043thra_lls
thrave126010273thrave__
thrivers14456823thrivers
thrives134611713thrive_s
tinsels738373tinsels
tirades8311723tirade_s
towels94314643t_owels
trace75829613trace__
traced94821583trace_d
traceless11228643traceless
tracer84820233trace_r
tracery12399793tracery
tracheas13410273tracheas
trachle12311853trachle
trachles13311753trachles
trackers143512843trackers
tracks124818843tra_cks
tracts85019073tra_cts
trade65026043trade__
traded85717683trade_d
trader75218753trade_r
tragedy1234793tragedy
tragics10338083tragics
tragus749223tra_gus
traiks104013713tra_iks
trail55126773tra_il_
trailed83415673trailed
trailer73015393trailer
trailers82912913trailers
trainees82712063trainees
trainers83114633trainers
trains64725343tra_ins
traits65121983tra_its
traject1637043traject
trajects1744533trajects
trameled11309073trameled
tramless1037503tramless
trammel11357663trammel_
trampers123210373trampers
trample11299703trample
tramples122610203tramples
tramps105114453tra_mps
trams75327673tra__ms
trances93919643trances
tranks104017763tra_nks
tranqs155210313tra_nqs
trans54933043tra__ns
trapans92812463trapans
trapeses1039153trapeses
trapeze1836243trapeze
trapezes1936543trapezes
trappers123711023trappers
traps75727483tra__ps
trashers113013623trashers
trashes104119253trashes
trass56226473tra__ss
trasses74819323trasses
traumas938583traumas
travail1036543travail
traveling1349053traveling
travelled1356863travelled
traveller1266603traveller
travellers1364663travellers
traversal1243833traversal
traversals1353253traversals
traversed1344563traversed
traverser1244133traverser
traverses1246343traverses
travesty1444483travesty
travoise1145603travoise
trawl84915873tra_wl_
trawled113411523trawled
trawler104011903trawler
trawlers113310193trawlers
trawley13317303trawley
trawleys14284383trawleys
trayfuls1443473trayfuls
trays85623433tra__ys
treacles1039703treacles
treaders93311833treaders
treadles939693treadles
treaters83615823treaters
trebles9311443trebles
treens65317873tr_eens
trees55835763tr__ees
treks96016853tr__eks
tres46542903tr__e_s
tress55423163tr__ess
tressels8367653tressels
trets55928023tr__ets
trevet94818913treve_t
trews86118893tr__ews
treys85018213tr__eys
triages82613793triage_s
trials64319883tr_ials
tribals9610743tribals
tribes85119023tribe_s
triceps11267343triceps
trices84826333trice_s
triens65417543tr_iens
triers64321523tr_iers
tries55742813tr_ie_s
trifles103814823trifles
trijets14308263trijets
trikes105419493trike_s
trills64319853tr_ills
trimers94615143trimers
trines64132563trine_s
triols66117803tr_iols
tripes85324873tripe_s
triples94616873triples
tritely1039003tritely
trivet93721883trive_t
trokes104019263troke_s
trolls64613943tr_olls
trommels12254333trommels
trones65629283trone_s
tropes84824353trope_s
trotyls10236033trotyls
trove85221923trove__
trover95014663trove_r
trowel94211463trowel_
truces84916333truce_s
trues54925323tr_ue_s
trulls64110283tr_ulls
trunnels844513trunnels
tsades74310993tsade_s
tunnels7328723tunnels
turves94212693turve_s
twaes86513663twa_e_s
unravel1038063unravel_
uracils939373uracils
uraeus638793ura_eus
uranyls1034453uranyls
urares64519093urare_s
urases63723563urase_s
urates65027763urate_s
varves124414783varve_s
wavers125022473_wavers
waves115633923_wave_s
waveys15597013_waveys
weasels10468503weasels
weavers133714463weavers
weaves123616373weave_s

Search took 9 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 Filter1786911340270.220812231.8
2DLD Change Limit1340275257.98616782.7
3Display Results5255250.2801875.0
 (SQL Overall)1786915258.48621057.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.