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

70 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
paravanes144830(None) 
paravane1348101paravane_
caravaned1544992caravaned
caravaner1444742caravaner
caravaners1544142caravaners
caravans1338622caravan_s
parasangs1246032parasangs
parataxes1846392parataxes
pavanes123612652p__avanes
carabines13311473carabines
caraganas1245793caraganas
carapaces1546053carapaces
carapaxes2044833carapaxes
caravan1239233caravan__
caravanned1652683caravanned
caravanner1552643caravanner
caravanners1652383caravanners
galavants1343943galavants
maryjanes2142993maryjanes
palatines11313033palatines
parables121613563para_bles
parades104121463par__ades
paradises122513203paradises
paradores12259653paradores
paradoses122510253paradoses
paradoxes19267293paradoxes
paraffines1844323paraffines
paragoges1347253paragoges
paragoned1357063paragoned
paragons11311503paragon_s
parakites1549543parakites
parallaxes1943683parallaxes
paralyses1448283paralyses
paralyzes2346493paralyzes
paramagnet1555743paramagnet
paramagnets1653673paramagnets
paraments13511553paraments
parangs104314373par__angs
parasails1147583parasails
parasang1147333parasan_g
parasites11313153parasites
parataxis1845473parataxis
parawings1535823parawings
parazoans2045603parazoan_s
parbakes1638343par_bakes
parians93519733par_ian_s
parkades1538273par_kades
parklands1654713parklands
parlances1348953par_lances
partakes1449923par_takes
partans94418283par_tan_s
parvenues1444643par_venues
parvenus1335653par_venus
parvises133911913par_vises
pavane114113443p__avane_
pavans115715593p__avan_s
pervades1437353per_vades
platanes102711883p_latanes
pralines102217723p_ralines
privates131812373p_rivates
profanes132311573p_rofanes
propanes122415823p_ropanes
purslanes1145523purslanes
pyruvates1743133pyruvates
ravages1139403__ravages
ravines104220233__ravines
sarabandes1344093sarabandes
sarabands1245593sarabands
stravages1345843stravages
warplanes1445893warplanes

Search took 9 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 Filter1786911486410.486367677.0
2DLD Change Limit148641708.18618158.0
3Display Results70700.0631111.1
 (SQL Overall)178691708.73520456.9
 
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.