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

80 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
pint66963181pint_
pinta75727051pinta
pinto75625751pinto
pints75936221pints
bint67355052bint_
bints76130182bints
dint56759062dint_
dints67431312dints
hint77455752hint_
hints87330622hints
inti46626082_inti
into45026152_into
lint416266242lint_
lints57137192lints
linty87126562linty
mint66758072mint_
mints76834042mints
minty106323902minty
ninth8314582ninth
paint75443692paint_
paints85921832paints
painty114714752painty
pant66061262pant_
panto76129412panto
pants76536922pants
panty105929302panty
pent66559072pent_
pieta75421752pieta
piety105817302piety
pin57066732pin__
pina65842642pin_a
pinas75434452pinas
pinata83817222pinata
pinch125619302pinch
pine67755722pin_e
pined85935322pined
pines76048862pines
pineta85815562pineta
piney105727502piney
ping75943602pin_g
pingo87122712pingo
pings85830882pings
pinite8321242pinite
pink107039392pin_k
pinko115618252pinko
pinks115729382pinks
pinky145823402pinky
pinna75320182pinna
pinny105222062pinny
pinon76024532pinon
pinot78737292pinot
pinots85920272pinots
pins65558462pin_s
pintas85021392pintas
pintle83818262pintle
pintos86021292pintos
pinup9612882pinup
piny911838362pin_y
piste75824602piste
pit56471932pi_t_
pita65436442pi_ta
pith95432702pi_th
pits66348752pi_ts
pitta75018692pitta
pity96031942pi_ty
plinth11310452plinth
point75338732point_
pointe84619312pointe
points85618532points
pointy114913282pointy
print74837462print_
prints84320102prints
punt65747202punt_
punto75121322punto
punts75828002punts
punty106021612punty
spinto8410662spinto
tint46758872tint_
tints56030922tints
zineb165614142zineb

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 Limit53800801.65632487.9
3Display Results80800.0302666.7
 (SQL Overall)178691802.01288812.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.