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

171 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
traverse113621(None) 
traversed1344561traversed
traverser1244131traverser
traverses1246341traverses
averse95811182__averse
bravers124715522bravers_
cravers124416542cravers_
gravers114515262gravers_
ravers94628182_ravers_
reverse103913742_reverse
tracers94917832tracers_
traders84316942traders_
transverse1345892transverse
travels104711292travels_
traversal1243832traversal
traversers13113292traversers
traves94222742trave_s_
travoise1145602travoise
trovers103713312trovers_
adverse1145953_adverse
avers85127313__avers_
beavers124417323beavers_
bracers114616703bracers_
braver114719043braver__
braveries1439103braveries
bravery15428133braver_y
braves115524083brave_s_
bravest124211753brave_st
bravure1254393bravur_e
brayers124511903brayers_
brazers184513943brazers_
carvers124817533carvers_
cavers115026833_cavers_
clavers124314893clavers_
converse13310263converse
craters95021883craters_
cravens124010113cravens_
craver114618463craver__
craves115825393crave_s_
diverse11429993_diverse
drapers105313353drapers_
drawers113610073drawers_
drivers114412793drivers_
drovers115212643drovers_
erasers74413943erasers_
framers125113823framers_
fraters103517203fraters_
graders94715993graders_
graters85419733graters_
gravels113611143gravels_
graver105018593graver__
graves104624003grave_s_
gravest114011633grave_st
gravure1134953gravur_e
gravures1234903gravures
grazers175112443grazers_
havers124721483_havers_
heavers133717193heavers_
inverse10249643_inverse
kraters114212333kraters_
lavers94526363_lavers_
leavers103717783leavers_
obverse1234753_obverse
pavers115021823_pavers_
perverse1336103perverse
praters94921643praters_
prayers124212853prayers_
preavers13910263preavers_
provers123817793provers_
quavers19309003quavers_
racers84725433_racers_
rakers104123573_rakers_
rapers84327183_rapers_
rasers64526783_rasers_
raters63936573_raters_
ravels94717073_ravels_
ravens93916883_ravens_
raver85631493_raver__
raves85441973_rave_s_
razers154919613_razers_
reavers108320743reavers_
revere94621253_rever_e
reveres103621343_reveres
reverie103615163_reverie
revers94529633_revers_
reversed122711613_reversed
reverser113010483_reverser
reverses112513513_reverses
reverso10367693_reverso
rivers94626543_rivers_
rovers95423523_rovers_
savers93825923_savers_
shavers134115093shavers_
slavers103716503slavers_
starvers11459643starvers_
strafers11379903strafers_
strayers113510133strayers_
strivers113911843strivers_
tabers84621573t_abers_
takers103923743t_akers_
talers64628143t_alers_
tamers84224033t_amers_
tapers84025813t_apers_
taters64932193t_aters_
tavern9428933t_aver_n
taverna10285383t_averna
taverner1134423t_averner
taverns10317803t_averns
tawers94118603t_awers_
taxers134015283t_axers_
tearers75218233tearers_
teasers75317243teasers_
terse55026823t___erse
thalers106212263thalers_
thawers13428483thawers_
thraves13469713thrave_s_
thrivers14456823thrivers_
trabeate1049483trabeate
tracer84820233tracer__
traceried1247143traceried
traceries11312853traceries
tracery12399793tracer_y
traces85329933trace_s_
trackers143512843trackers_
trader75218753trader__
trades75724493trade_s_
trailers82912913trailers_
trainers83114633trainers_
traipse935873tra_ipse
tramels93812493tramels_
trampers123210373trampers_
transverses1445903transverses
trapes85024463trape_s_
trapesed1136473trape_sed
trapeses1039153trape_ses
trapeze1836243trape_ze
trapezes1936543trapezes
trappers123711023trappers_
trappose1245813trappose
trashers113013623trashers_
trave85223033trav___e
travel94112983trave__l
traveled12349453traveled
traveler11328433traveler
travelers12266773travelers_
travelled1356863travelled
traveller1266603traveller
travelog1243513travelog
traversable1652813traversable
traversals1353253traversals
traversing1444793traversing
travertine1345413travertine
travesty1444483travesty
travois1037873travois_
travoises1245853travoises
trawlers113310193trawlers_
treaders93311833treaders_
treaters83615823treaters_
trevets10499973trevets_
triers64321523tr_iers_
trimers94615143trimers_
trivets103911583trivets_
trouvere1144053trouver_e
trouveres1243763trouveres
trover95014663trover__
troves94719113trove_s_
universe1145253universe
untraversed1553083untraversed
verse84723583___verse
wavers125022473_wavers_
weavers133714463weavers_

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461621718.51617163.2
3Display Results1711710.0632714.3
 (SQL Overall)1786911718.75220417.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.