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

57 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
parasail104923(None) 
parasails1147581parasails
parafoil1345972parafoil
parasailed1344072parasailed
parasang1147332parasang
parasol939552paras_ol
phrasal1246162phrasa_l
assail6610153_a_ssail
brasil8713863_bras_il
caracal11312513caraca_l
faradaic1443653faradaic
foresail1147823foresail
mainsail1045173mainsail
marasmic1446163marasmic
palatal9310153palata_l
palatial10410623palatial
paradisaic1554223paradisaic
paradisal1246883paradisa_l
paradisial1354803paradisial
paraffin1644903paraffin
parafoils1445503parafoils
parallel1047473parallel
paranoia10410563paranoia
paranoic1249833paranoic
paranoid11311143paranoid
paras76143043paras___
parasailing1444333parasailing
parasangs1246033parasangs
parashah1646453parashah
parashahs1744743parashahs
parashot13410143parashot
parasite10314843parasite
parasitic1349523parasitic
parasols1039263parasols
parataxis1845473parataxis
paravane1348103paravane
parboil1138323par_boil
paresis93315093pares_is
parfait12312053par_fait
parosmia1245953parosmia
parral85517533par_ra_l
parsable12311693par_sable
parsnip1146323par_snip
partial92616263partia_l
pastil85018323p__astil
patagial1157173patagial
pausal81511963pa_usa_l
perusal939193perusa_l
pharisaic1644633pharisaic
phrasally1742823phrasally
prevail1238243p_revail
prosaic11311163p_rosaic
resail64418733__resail
tarsal63315273tar_sa_l
travail1036553_travail
trysail1044543_trysail
wassail1056133wa_ssail

Search took 8 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.420425454.8
2DLD Change Limit146162577.23620199.3
3Display Results57570.0163562.5
 (SQL Overall)178691577.67223291.3
 
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.