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

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

83 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
pantie8432647(None) 
panties94230931panties
pantile93918481pantile
pastie85525521pastie
pattie84020961pattie
antae56828292_antae
ante46538902_ant_e
anti45536362_anti_
antic75728862_antic
antis55033312_antis
antre55224522_antre
auntie64317702auntie
banties94324762banties
bawtie113812142bawtie
cannie83819362cannie
cantic103920532cantic
cantle84522152cantle
cattie85221012cattie
dautie72914692dautie
dawtie103011092dawtie
hankie133915712hankie
hantle94318202hantle
mantic104120902mantic
mantid93820372mantid
mantis83926032mantis
mantle84420922mantle
nannie63713222nannie
paintier1048792paintier
pandied113913442pandied
pandies104224502pandies
pandit93820752pandit
pane64950282pan__e
panic93923902pan_ic
panier84425502pan_ier
panne76623652pan_ne
pannier93613352pannier
panpipe1034832panpipe
pansies94521982pansies
pant66061252pant__
panted95024822panted
panther12611442panther
pantiled113111592pantiled
pantiles103617152pantiles
panting104025422panting
panto76129412pant_o
pantos85222742pantos
pantries101817392pantries
pantry115014102pantry
pants76536922pant_s
panty105929302pant_y
pardie96021442pardie
partied103516552partied
partier93520712partier
parties93230862parties
partite9317132partite
paste74932952past_e
pastier94320382pastier
pasties94529812pasties
pastil85018322pastil
pastime114611972pastime
pastis84924322pastis
pate65350462pa_t_e
patin76832852pa_tin
patine85328122pa_tine
patio74426352pa_tio
pattee84323382pattee
patties93425142patties
pinite8321242pinite
pinkie124414272pinkie
pintle83818262pintle
pontil8315462pontil
pontine92419052pontine
postie84123962postie
punkie123513612punkie
punties94520782punties
puttie84116302puttie
saltie63422422saltie
santir6315242santir
tattie64817512tattie
tentie62521182tentie
untie54425492_untie
vauntie1036632vauntie
vawntie1343942vawntie

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 Filter178691825510.1261418182.5
2DLD Change Limit82551832.96627832.4
3Display Results83830.0165187.5
 (SQL Overall)178691833.10857493.9
 
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.