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 “bypaths” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

90 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
bypaths174319(None) 
bypath1645351bypath_
baths105922922b__aths
breaths124411182breaths
bypass1345042bypa_ss
paths105521382__paths
apathy1437033_apathy
ayahs116813523ay_a_hs
bahts105617803b__ahts
balatas9311833balatas
bates75846343b__ates
bath95940083b__ath_
bathe105822883b__athe
bathes116524833b__athes
bathos116215633b__athos
bats66962333b__at_s
batts76727563b__atts
beats76042243b_eat_s
berates94126873berates
berths114712423b_erths
beths105519223b__eths
bimahs13508303bima_hs
bipacks1745043bipacks
births115713603b_irths
blahs105616513b_la_hs
blats75132503b_lat_s
bleats85518613bleat_s
bloats85215763bloat_s
boats75635153b_oat_s
booths115313793b_ooths
borates94823013borates
brachs134415753b_rachs
brats75336013b_rat_s
breadths1474463breadths
breath113916263breath_
breathe123711843breathe
breathes134212903breathes
breathy15328033breathy
briths115113863b_riths
broths115013923b_roths
bycatch1942063bycatch
bycatches2142683bycatches
bylaws14415833byla_ws
bynames14256243bynames
bypasses1533833bypasses
bypast13117373bypa_st
byplays1743103byplays
bytalks1632713bytalks
bytes105217493by__tes
byways1734673bywa_ys
byzants2153223byzants
deaths105914443_deaths
depths12428573dep_ths
empathy1743483empathy
expats1537683expat_s
gyrates113610263gyrates
heaths126316383_heaths
kyats125012443ky_at_s
laths86022403__laths
lysates10317473lysates
maths105624023__maths
mynahs14416443myna_hs
myopathy2143113myopathy
myths135911603my__ths
oaths86117313__oaths
opahs105411983_opa_hs
pates76047893__pates
path99134913__path_
pathos115516693__pathos
pats66460853__pat_s
piths105817543__piths
pupates113311433pupates
sheaths1358753sheaths
snaths95112913_snaths
spates85028173_spates
spathe115115693_spathe
spathes125116533_spathes
spats75031383_spat_s
straths102711723straths
swaths125312643_swaths
sympathy2143613sympathy
synths12377883sy_nths
syphs13519453syp__hs
towpaths1643113towpaths
warpaths1643973warpaths
wraths123810083_wraths
wreaths13338373wreaths
yeahs115214553_yea_hs
yirths12639533_yirths
youths124510043_youths

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.390458182.1
2DLD Change Limit134027906.23621492.5
3Display Results90900.0303000.0
 (SQL Overall)178691906.65626846.6
 
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.