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

188 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
travois103788(None) 
travoise1145601travoise
bravoes12418532bravoes
bravos114711392bravo_s
travail1036552travail
travails1146082travails
travels104711292travels
traves94222742trav_es
travoises1245862travoises
trois57226092tr__ois
arvos86015663ar_vo_s
avoid95516683__avoid
avoids104410203__avoids
avos77227013__avo_s
avows114910983__avows
bravas114913323brav_as
bravers124715523bravers
braves115524083brav_es
bravi104715753brav_i_
bravo105214343bravo__
bravoed13436113bravoed
bravoing1445993bravoing
chamois143512193chamois
cramoisy1543703cramoisy
crasis85020473cra_sis
cratons94316033cratons
cravats1237403cravats
cravens124010123cravens
cravers124416563cravers
craves115825393crav_es
crayons12439233crayons
dragons938383dragons
envois988703_envois
favors124211403_favors
flavors1337293flavors
frivols1334743frivols
gavots1038113_gavots
gratis74819243gra_tis
gravels113611143gravels
gravers114515273gravers
graves104624003grav_es
gravid113710983grav_id
gravies11314093gravies
havocs1435653_havocs
mavis105622723_mav_is
orators7313823orators
parvis116114803parv_is
parvos116614753parvo_s
patois84319363_patois
pavis106422733_pav_is
praos74923563pra_o_s
praxis154012253pra_xis
rabbis102613163_rabbis
rachis114017653_rachis
racons84319343_racons
radios74018673_radios
radons74118533_radons
ragis66325603_ra_gis
rais45252623_ra__is
rakis95323443_ra_kis
ramous8417113_ramous
ranis55235833_ra_nis
raphis114014323_raphis
ratios64922673_ratios
ratos55528763_rato_s
ravels94717073_ravels
ravens93916883_ravens
ravers94628183_ravers
raves85441973_rav_es
ravin85624653_rav_in
ravins94622563_ravins
raviolis1146103_raviolis
ravish123414033_rav_ish
rayons94113343_rayons
razors154711663_razors
reavows1335273reavows
renvois1036503renvois
savors95616103_savors
savoys12427893_savoys
shamois123210423shamois
stratous8410703stratous
stravaig1243013stravaig
stravaigs1342723stravaigs
tabbis102910863t_abbis
taboos83815433t_aboos
tabors84517113t_abors
tacos77023553t_aco_s
tallis63319963t_allis
talons64019443t_alons
tamis76728733t_a_mis
taos45541003t_a_o_s
tapis75028863t_a_pis
tarocs84615663t_arocs
taroks106115283t_aroks
taros55640823t_aro_s
tarots66422993t_arots
tarpons92612213tarpons
tatsois748373tatsois
tauons63412673t_auons
tavs75630973t_av__s
taxis126821973t_a_xis
taxols13328633t_axols
taxons134211503t_axons
teapots939053teapots
teapoys1235963teapoys
terais64023513tera__is
teratoid9411073teratoid
thraves13469713thrav_es
tracers94917843tracers
traces85329933tra_ces
tracks124818843tra_cks
tractors10312573tractors
tracts85019073tra_cts
traders84316953traders
trades75724503tra_des
traffic1544733traffic
traffics1644183traffics
tragi64717173tra_gi_
tragic93811553tra_gic
tragics10338083tragics
tragus749233tra_gus
traik95418203tra__ik
traiks104013713tra_iks
trail55126773tra__il
trails64622513tra_ils
train56529113tra__in
trains64725343tra_ins
trait56940843tra__it
traitors8310793traitors
traits65121983tra_its
tramels93812493tramels
trampish1535653trampish
tramps105114453tra_mps
trams75327673tra__ms
trances93919643trances
tranks104017763tra_nks
trannies8415013trannies
tranqs155210313tra_nqs
trans54933043tra__ns
transit7317163transit
transits8313503transits
transoms1048933transoms
trapans92812463trapans
trapes85024463tra_pes
trappous1246023trappous
traps75727483tra__ps
trashes104119263trashes
trass56226473tra__ss
trasses74819323trasses
traumas938593traumas
trave85223033trav__e
travel94112983trav_el
travelogs1343383travelogs
traverse1136213traverse
trawls94412393tra_wls
trays85623433tra__ys
treasons848683treasons
trefoil1066063trefoil
trefoils1145303trefoils
trellis739873trellis
tremors93711233tremors
trevets10499973trevets
tricots9311563tricots
trigons84312093trigons
trigos74214173trigo_s
triols66117803tr_iols
trios55528093tr_io_s
tripods10359053tripods
tripolis1038713tripolis
tripos84014923tripo_s
tritons73814883tritons
trivets103911583trivets
trivia938503triv_ia
trogons83410723trogons
trogs67022603tr__ogs
troops85712783tr_oops
trots56629943tr__ots
trovers103713323trovers
troves94719113trov_es
trows88826183tr__ows
troys86418613tr__oys
tsadis7429133tsa_dis
turacos938643turaco_s
turacous1047143turacous
turkois1135133turkois
turquois1742453turquois
uranous7310733uranous
uraris63817273ura_ris

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271886.20321606.8
3Display Results1881880.0762473.7
 (SQL Overall)1786911886.68526730.1
 
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.