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

36 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
pineals9321284(None) 
pineal84817681pineal_
anneals7449942anneals
cineols9128852cineols
finals94316162fin_als
finials103210152finials
gingals9109312gingals
ideals75012502_ideals
jingals1588072jingals
lineal65616022lineal_
minerals10311382minerals
panels84716522pane_ls
peals75235492p__eals
pibals103813082pi_bals
pinas75434452pin_a_s
pinball1137932pinball
pinballs1246932pinballs
pinenes93416672pinenes
pines76048862pine__s
pinesaps1253982pinesaps
pinheads14336242pinheads
pinnal84814272pinnal_
pinnas85315512pinna_s
pintails10310162pintails
pintas85021392pinta_s
pinwale1257842pinwale
pinwales1367962pinwales
pipals104213642pi_pals
pixels15478532pixe_ls
spinals93911862spin_als
spinels94512442spine_ls
tincals93610642tincals
tineal66216162tineal_
tineas64616482tinea_s
vinals94716482vin_als
vineal94814742vineal_

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.373479064.3
2DLD Change Limit107671363.31332499.5
3Display Results36360.0162250.0
 (SQL Overall)178691363.70248268.8
 
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.