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

64 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
parabola124665(None) 
parabolas1347001parabolas
carambola1542852carambola
parable111819772parab_le
parabolic1546282parabolic
paranoea1048562paranoea
paranoia10410562paranoia
parasol939552parasol_
parasols1039262parasols
arabica1147283_arabica
arable81821003_arab_le
araroba945763_araroba
areola6813673_ar_eola
arugola844353_arugola
caracol11310423caracol_
caracole12310353caracole
caracols12310413caracols
carambolas1643373carambolas
carbora11310703car_bora
crapola1136913_crapola
granola837913_granola
marabou1147493marabo_u
marabous1249063marabous
marabout1249103marabout
palabra1137183palab_ra
panatela1044913panatela
parablast1347093parab_last
parables121613563parables
paraboloid1554083paraboloid
parador103311413parado_r
paradors113411903paradors
parados103816053parado_s
paradox17358173parado_x
parafoil1345973parafoil
parafoils1445503parafoils
paraform1546933paraform
paragoge1257153paragoge
paragon10311023parago_n
paragons11311503paragons
parallax1745643para_llax
paramo102614643paramo__
paramos113213513paramo_s
paramour1246083paramour
paranoeas1147523paranoeas
paranoiac1346263paranoiac
paranoias11410443paranoias
paranoic1249833paranoic
paranoid11311143paranoid
parapodia1445513parapodia
parasoled1246353parasoled
parazoan1946553parazoan
parboil1138323par_boil
parboils1237433par_boils
parol74826273par__ol_
parole84425253par__ole
parols84722613par__ols
parsable12311693parsab_le
payable141711323payab_le
payably17177093payab_ly
payola11208113p__ayola
pergola1067623per_gola
pyrola1139003pyr__ola
sparable121611983sparab_le
variola1068893var_iola

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.423422437.4
2DLD Change Limit146162647.50019488.3
3Display Results64640.0164000.0
 (SQL Overall)178691647.93922508.0
 
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.