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

62 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
parvolin137693(None) 
parvoline1477171parvoline
parvolins1486701parvolins
pangolin1147772pangolin
paroling113316212par_oling
parvolines1586002parvolines
carbolic1448323carbolic
carlin84421823car__lin
caroli85918233car_oli_
caroling113317003car_oling
carotin92216733car_otin
carrotin102210893carrotin
caryotin13268353caryotin
javelin17306983ja_velin
kaolin1039583ka__olin
karyotin15194833karyotin
lanolin7310643la_nolin
mandolin1148583mandolin
marlin84220913mar__lin
marveling1537103marveling
pangolins1247373pangolins
parabolic1546283parabolic
paraffin1644913paraffin
parboil1138323parbo_il
parboiling1545173parboiling
parboils1237433parboils
parceling1438443parceling
pardon94618733pardo__n
pardoning1338763pardoning
pargyline1544653pargyline
parhelia1346713parhelia
parhelic1547093parhelic
parhelion1444223parhelion
parling103823763par__ling
parodic122311723par_odic
parol74826273par_ol__
parole84425253par_ol_e
paroled104217633par_oled
parolee94119653par_olee
paroles95025893par_oles
parols84722613par_ol_s
parotic112518043par_otic
parotid102915513par_otid
parroting1239153parroting
parson83817903parso__n
parsonic1239703parsonic
parton84720993parto__n
parvis116114803parv__is
parvo107719183parvo___
parvos116614753parvo__s
paulin8312983pa__ulin
pavilion1344903pa_vilion
pavin105623203pa_v__in
pavonine1346663pa_vonine
picolin11310883p_icolin
prolan8414693p_r_olan
proline92321593p_r_oline
prolix1538683p_r_olix
purlin83615863pur__lin
purloin9107493purlo_in
pyrrolic1544563pyrrolic
ravelin102211023ra_velin

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.406440125.6
2DLD Change Limit146162626.81321453.4
3Display Results62620.0302066.7
 (SQL Overall)178691627.24924650.4
 
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.