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

128 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
bypath164535(None) 
bypaths1743191bypaths
bath95940082b__ath
breath113916262breath
bycatch1942062bycatch
bypass1345042bypass
bypast13117372bypast
path99134912__path
apathy1437033_apathy
ayah108022993ay_a_h
bach116131393b__ach
bah87755353b__a_h
baht96740013b__aht
baith108023133b_aith
balata8614683balata
bash915240163b__ash
bat510988953b__at_
batch124620103b__atch
bate66552423b__ate
bathe105822883b__athe
baths105922923b__aths
bats66962333b__ats
batt65053873b__att
beach124623893b_each
beat66168303b_eat_
beats76042243b_eats
begat86629723begat_
bemata10411693bemata
beneath1236973beneath
berate84729023berate
berth104917883b_erth
beth96629233b__eth
bimah127013273bima_h
binate8419773binate
bipack1636523bipack
biparty1445583biparty
birth105619873b_irth
blah98625063b_la_h
blat66550953b_lat_
blate75933783b_late
blats75132503b_lats
bleach133611403bleach
bleat75737003bleat_
bleats85518613bleats
bloat75229923bloat_
bloats85215763bloats
boat66360313b_oat_
boats75635153b_oats
booth105522013b_ooth
borate85026153borate
both96533433b__oth
brach126123303b_rach
brash106221563b_rash
brat66055543b_rat_
brats75336013b_rats
breach134213723breach
breadth1365993breadth
breathe123711843breathe
breaths124411193breaths
breathy15328033breathy
brith104924373b_rith
broach133611113broach
broth106521093b_roth
bylaw13408603byla_w
bylaws14415833bylaws
byname13256363byname
byplay1634193byplay
byplays1743103byplays
bytalk1533473bytalk
byte96521813by__te
byway1647533bywa_y
byways1734673byways
byzant2096813byzant
byzants2153223byzants
death94822523_death
depth114311853dep_th
eath75735663__eath
empathy1743483empathy
expat14313813expat_
expats1537683expats
gyrate104912523gyrate
hath105933913__hath
heath115724283_heath
kyat116025533ky_at_
kyats125012443ky_ats
lath76640383__lath
loath84918603_loath
lyrate94112103lyrate
lysate9388103lysate
math95437453__math
mynah13569563myna_h
myopathy2143113myopathy
myth126715433my__th
neath86020283_neath
oath76132153__oath
opah96218403_opa_h
pah88853593__pa_h
pash95638133__pash
pat58089463__pat_
patch125221223__patch
pate65350463__pate
paths105521383__paths
pats66460853__pats
paty95234563__paty
pith95432703__pith
pupate104213123pupate
rath76037663__rath
repatch1435843repatch
sheath12412893sheath
snath86419803_snath
spat66548523_spat_
spate74731583_spate
spathe115115693_spathe
spats75031383_spats
strath93216373strath
swath115920383_swath
sympathy2143613sympathy
synth113711823sy_nth
syph125413273syp__h
towpath1544043towpath
typal105311153typa_l
warpath1545203warpath
wrath115715873_wrath
wreath124111193wreath
yah99046353_y_a_h
yeah106725413_yea_h
yirth116513753_yirth
youth115315043_youth

Search took 6 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 Filter1786911127160.373479064.3
2DLD Change Limit1127161285.36021029.1
3Display Results1281280.0462782.6
 (SQL Overall)1786911285.77930920.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.