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

133 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
patsy10571720(None) 
palsy105417461palsy
pansy105717971pansy
pasty105725051pasty
patly105020581patly
pats66460851pats_
patty104723611patty
paty95234561pat_y
potsy105815611potsy
antsy85712792antsy
apathy1437032apathy
aptly105111812aptly
artsy86012962artsy
bassy1012917102bassy
bats66962332bats_
batty105422242batty
bitsy104511302bitsy
cats66356342cats_
catty104520412catty
daisy95915312daisy
ditsy95612562ditsy
easy76224492ea_sy
eats47054872eats_
fatly115716802fatly
fats76252502fats_
fatso85113492fatso
fatty115117412fatty
gassy95514022gassy
gats56753442gats_
gawsy12459092gawsy
gutsy96412842gutsy
hasty115718762hasty
hats76858252hats_
kats85944332kats_
lathy115215062lathy
lats45962702lats_
massy104518962massy
matey107022662matey
mats65460292mats_
nasty85717282nasty
natty85719142natty
nutsy85711502nutsy
oats46554212oats_
pacey126720282pacey
pacs85842182pacs_
pacts95125802pacts_
pacy115328682pa_cy
paddy125913592paddy
pads76742952pads_
paisa76021072paisa
paise75028332paise
pally105727122pally
palmy126016732palmy
pals66951352pals_
paltry114910402paltry
paly95835532pa_ly
pams85641762pams_
pandy115021172pandy
pans65855732pans_
pantry115014102pantry
pants76536922pants_
panty105929302panty
pappy114713802pappy
paps86443452paps_
pardy115523952pardy
parry105323752parry
pars67560792pars_
parse75236992parse
partly116315472partly
parts77743372parts_
party106630612party
pas58775742pa_s_
pase65346862pa_se
pash95638132pa_sh
pass65239952pa_ss
passe75525692passe
past65959012pa_st
pasta76624532pasta
paste74932952paste
pastry114913032pastry
pasts75936502pasts
pat58089462pat__
patch125221222patch
patchy16509572patchy
pate65350462pat_e
pated85237842pated
paten74827342paten
pater74740722pater
pates76047892pates
path99134912pat_h
paths105521382paths
patin76832852patin
patio74426352patio
pause75021832pause
pawky173810152pawky
paws96038182paws_
pay88461182pa__y
pays95940222pays_
peats76140192peats_
peaty105725692peat_y
pesty106421712pesty
pets66248332pets_
petty105320292petty
pithy135614462pithy
pits66348742pits_
pity96031932pit_y
plats75531372plats_
platy105021662plat_y
platys11459852platys
poesy105014062poesy
popsy125713402popsy
posy96028422p_osy
pots66452362pots_
potty105621002potty
prats76333392prats_
prosy106319252prosy
pursy105016412pursy
pussy105614842pussy
puts65641752puts_
putty104721402putty
qats135331342qats_
rats46260372rats_
ratty84819592ratty
sassy85813812sassy
satay84718462satay
spats75031382spats_
tansy84514942tansy
tasty84820312tasty
tats46858132tats_
tatty84720182tatty
vasty116215922vasty
vats76841742vats_
wats77555882wats_

Search took 3 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.326548131.9
2DLD Change Limit538001332.37622643.1
3Display Results1331330.0632111.1
 (SQL Overall)1786911332.76564626.0
 
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.