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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

189 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
paths10552138(None) 
baths105922921baths
laths86022401laths
maths105624021maths
oaths86117311oaths
pates76047891pates
path99134911path_
pathos115516691pathos
pats66460851pat_s
piths105817541piths
aahs716428562_aahs
ahs68644822_a_hs
apathy1437032apathy
ates45047922_ates
bahts105617802bahts
bates75846342bates
bath95940082bath_
bathe105822882bathe
bathes116524832bathes
bathos116215632bathos
bats66962332bat_s
batts76727562batts
beths105519222beths
bypaths1743192bypaths
caphs124515372caphs
cates75951872cates
cats66356342cat_s
dahs88231812da_hs
dates65639152dates
datos65222782datos
deaths105914442deaths
earths95014592earths
eath75735662eath_
eats47054872eat_s
eths76619522_eths
faiths124610272faiths
fates85139232fates
fats76252502fat_s
garths104111502garths
gates65939502gates
gats56753442gat_s
goths96513002goths
hahs108333362ha_hs
hates86742572hates
hath105933912hath_
hats76858252hat_s
heaths126316382heaths
heths116317782heths
jatos125116822jatos
kaphs144911502kaphs
katas95922092katas
kats85944332kat_s
kiths125814972kiths
lakhs125210342lakhs
lath76640382lath_
lathe85626712lathe
lathes95127492lathes
lathi85417202lathi
lathis95516172lathis
lathy115215062lathy
lats45962702lat_s
machs125722562machs
mates75251362mates
math95437442math_
mats65460282mat_s
matts76829182matts
meths105320232meths
moths106021552moths
myths135911602myths
nates55238332nates
oath76132152oath_
oats46554212oat_s
opahs105411982opa_hs
pacas96029402pacas
paces96741112paces
pacha126518062pacha
pachas135017142pachas
packs135528932packs
pacs85842182pa_cs
pacts95125802pacts
padis86227142padis
pads76742952pa_ds
pages85235072pages
pah88853592pa_h_
paiks114719852paiks
pails75833062pails
pains75138282pains
pairs75325832pairs
pales75753802pales
palls74332562palls
palms94921752palms
palps94719562palps
pals66951352pa_ls
pams85641762pa_ms
panes76148692panes
pangs84628662pangs
pans65855722pa_ns
pantos85222742pantos
pants76536922pants
papas94927492papas
paps86443452pa_ps
paras76143042paras
pards85634332pards
pares77164482pares
paris75145942paris
parks116134462parks
parrs75928672parrs
pars67560792pa_rs
parts77743372parts
pas58775742pa__s
pases75346502pases
pash95638132pash_
pasha105417182pasha
pashas115117062pashas
pashes115828392pashes
pass65239952pa_ss
pastas85422872pastas
pastes85233912pastes
pastis84924322pastis
pasts75936502pasts
pat58089462pat__
patch125221222patch
patches143320382patches
patchy16509572patchy
pate65350462pat_e
pated85237842pated
paten74827342paten
patens84820862patens
pater74740722pater
paters84935822paters
patin76832852patin
patins87528782patins
patio74426352patio
patios85221782patios
patly105020582patly
patois84319362patois
patsy105717202patsy
patty104723612patty
paty95234562pat_y
paves104833922paves
pavis106422732pavis
pawls105617662pawls
pawns108818132pawns
paws96038182pa_ws
paxes144928422paxes
pays95940222pa_ys
peats76140192peat_s
pechs125516202pechs
pehs95625762p_ehs
pets66248332pet_s
pitas77427672pitas
pith95432692pith_
pithy135614462pithy
pits66348742pit_s
plates85432242plates
plats75531372plat_s
platys11459852platys
poohs103915712poohs
pothos114214692pothos
pots66452362pot_s
prates84633162prates
prats76333392prat_s
puts65641752put_s
putts75719272putts
qats135331342qat_s
rates55352012rates
rath76037662rath_
rathe85821922rathe
ratos55528762ratos
rats46260372rat_s
ruths85714642ruths
sates54949322sates
satis55633672satis
snaths95112912snaths
soths86218622soths
spates85028172spates
spathe115115692spathe
spathes125116532spathes
spats75031382spat_s
swaths125312642swaths
tachs105820932tachs
tates55444982tates
tats46858132tat_s
teths85418512teths
vats76841742vat_s
vatus86114642vatus
wats77555882wat_s
watts86923092watts
wraths123810082wraths

Search took 5 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 Filter178691538000.343520965.0
2DLD Change Limit538001894.00013450.0
3Display Results1891890.0932032.3
 (SQL Overall)1786911894.43640282.0
 
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.