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

116 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
patties9342514(None) 
catties94023051catties
fatties103018201fatties
panties94230931panties
parties93230861parties
pasties94529811pasties
patsies93919481patsies
pattie84020961pattie_
potties93723541potties
putties94420021putties
tatties74120341tatties
apathies1339002apathies
apatites10311292apatites
attics84413282_attics
attires72312952_attires
banties94324762banties
battier93515712battier
battiest104115552battiest
battiks1337142battiks
battles94517682battles
battues94610192battues
bawties124214312bawties
butties93217952butties
cattie85221022cattie_
cattier93317072cattier
cattiest103016332cattiest
cutties93118842cutties
dauties83315762dauties
dawties113312702dawties
ditties83116982ditties
fattier103513462fattier
fattiest113514312fattiest
hotties103016962hotties
jetties143613122jetties
jutties143814002jutties
kitties113213622kitties
laities7320342laities
lattes65324202latt_es
lattices1038382lattices
lattins74115482lattins
mattes85624532matt_es
mattins93316142mattins
nasties73520492nasties
nattier73614622nattier
nattiest83215352nattiest
paddies113715722paddies
palsies94420272palsies
pandies104224502pandies
pansies94521982pansies
pantie84326472pantie_
pantiles103617152pantiles
pantries101817392pantries
pappies103214822pappies
paries84742512pa_ries
parities10522972parities
parries93925842parries
partied103516552partied
partier93520712partier
partiers103514242partiers
pastes85233912past_es
pastie85525522pastie_
pastier94320382pastier
pastiest103319542pastiest
pastils94416172pastils
pastimes123611902pastimes
pastis84924322pasti_s
pastises103616052pastises
pastries101517422pastries
patches143320382patches
pates76047892pa_t_es
patines95225762patines
patins87528782pa_tins
patios85221782pa_tios
patois84319362patoi_s
patooties1147182patooties
patted94724682patt_ed
pattee84323382patt_ee
patten84418192patt_en
pattens95414922pattens
patter84628262patt_er
patters94825192patters
patting103722342patting
petites93820202petites
pettier94213612pettier
pettiest103113962pettiest
pettles93916482pettles
pieties9419222pieties
pities83828082p_ities
platies93722542platies
plotties103111412plotties
posties93128812posties
potpies113116172potpies
potsies93019482potsies
pottier93516492pottier
pottiest102815972pottiest
pottles93816982pottles
prattles10189402prattles
pretties10615132pretties
punties94520782punties
puttees93612912puttees
puttie84116302puttie_
puttied103811162puttied
puttier93314502puttier
puttiers10288012puttiers
ratites74920682ratites
rattier74015592rattier
rattiest83516112rattiest
rattles73217302rattles
salties73725772salties
tattie64817512tattie_
tattier74216242tattier
tattiest83415382tattiest
tattles73616282tattles
titties73617362titties
tutties73216472tutties
wattles103814072wattles

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711163.43631336.1
3Display Results1161160.0462521.7
 (SQL Overall)1786911163.85846317.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.