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

43 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
pintsize195510(None) 
pintsized2153671pintsized
fantasize2196053fantasize
finalize202711023finalize
inosine7314283_inosine
inosite7314063_inosite
inside7613453_in_side
intime81014273_int_ime
intine61021983_int_ine
intwine1038513_intwine
kingside1444263kingside
midsize1946393mi_dsize
minimize2146063minimize
outsize162411753_outsize
pantie84326473pant_i_e
pantile93918483pant_ile
pectize20259913pect_ize
penalize19912753penalize
pensile92713543pen_sile
pensive122610393pen_sive
pentoside1255383pentoside
peptize20279483pept_ize
picturize2244463picturize
pinelike14188613pinelike
pinite8321243pin__ite
pinkie124414273pin_ki_e
pinstripe1343783pinstripe
pintail9311183pintai_l
pintailed1245553pintailed
pintails10310163pintails
pintle83818263pint__le
pints75936223pints___
poetize18310773poet_ize
pontine92419053pont_ine
portside1138163portside
potsie83916033p_otsi_e
rightsize2243653rightsize
ringside1045403ringside
sinicize1947333sinicize
uintaite8127353uintaite
unisize1647343_unisize
unitize16310033unit_ize
winterize2146923winterize

Search took 9 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 Filter1786911461620.453394461.4
2DLD Change Limit146162438.01318240.6
3Display Results43430.0162687.5
 (SQL Overall)178691438.48221067.1
 
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.