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

78 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
parades10412146(None) 
parade94720641parade_
paraded114014261paraded
parader103914861parader
paraders113113111paraders
parados103816051parados
parkades1538271parkades
abrades10312072abrades
arames84622572_arames
arcades101113192_arcades
bardes95026932bar_des
carafes125015702carafes
carates95630612carates
charades141310852charades
facades1339032facades
farads104713272farad_s
garages9314112garages
grades84926312_grades
irades74517392_irades
karates115617472karates
naiades838212naiades
palaces114216452palaces
palates93624932palates
panadas103312212panadas
parables121613562parables
paradise112113872paradise
paradises122513202paradises
parador103311412parador
paradores12259652paradores
paradors113411902paradors
paradoses122510252paradoses
paradox17358172paradox
paradoxes19267292paradoxes
parae76335702para_e_
paramos113213512paramos
parangs104314372parangs
parapet11317642parapet
parapets1239762parapets
paraphs1439312paraphs
paras76143042para__s
parbakes1638342parbakes
parches143720002parches
pardahs13289672pardahs
pardee93922022par_dee
pards85634332par_d_s
pares77164482par__es
pareses94718882pareses
parges94529542par_ges
paries84742512par_ies
parises94827182parises
parkade1437582parkade_
parles86334402par_les
parodies11313692parodies
parodos103011752parodos
paroles95025882paroles
parries93925842parries
parses85534702par_ses
partakes1449922partakes
parties93230862parties
parures9512692parures
passades1139202passades
pavanes123612652pavanes
paygrades1643622paygrades
pervades1437352pervades
pesades10310902pesades
phrases12711462phrases
pirates93020332pirates
pomades123711732pomades
prases84429022p_rases
prates84633162p_rates
praxes156215182p_raxes
prides94324182p_rides
prudes94215442p_rudes
sarapes94617742sarapes
sarodes84216142sarodes
tirades8311722tirades
trades75724502_trades
upgrades12216062upgrades

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.376475242.0
2DLD Change Limit107671783.54630364.1
3Display Results78780.0332363.6
 (SQL Overall)178691783.95545181.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.