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 “provenances” with Change Limit: [1] [2] [3] [4] [5]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

100 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
provenances185453(None) 
provenance1744491provenance_
proveniences1953672proveniences
governances17223913_governances
penances12312443p___enances
poignances1543443p_oignances
prefinances1875013prefinances
promenades1585413promena_des
prominences1744863prominences
provenience1853813provenience_
providences1953823providences
provinces1646853prov__inces
purtenances1553863purtenances
purveyances2152063purveyances
chrominances2152424chrominances
cofinances1745304_cofinances
conveyances2185204conveyances
cotenancies1545074_cotenancies
covenanted1663804_covenanted
covenantee1583944_covenantee
covenantees1672144_covenantees
covenanter1563604_covenanter
covenanters1682964_covenanters
covenants1445894_covenan_ts
dominances1545684_dominances
freelances1545224fr_eelances
governance1654044_governance_
grievances1643224gr_ievances
ordinances1344974or_dinances
ordnances1244754__ordnances
ordonnances1451954ordonnances
penance11313444p___enance_
penanced1338164p___enanced
permeances1645654perme_ances
perseverances2061844perseverances
poignance1443594p_oignance_
poignancies1652704p_oignancies
portances1349834p_o_rtances
potences12710694p_ote__nces
prances113618774pr____ances
precancel1546204pr__ecancel
precancels1644064pr__ecancels
precancer1547094pr__ecancer
precancers1645254pr__ecancers
precedences1845514precedences
predominances2093294predominances
preenacts1345844pr_eena_cts
prefaces15311064pr__efa_ces
preferences1876184preferences
prefinance1795444prefinance_
prefinanced1983184prefinanced
pregnancies1644564pr_egnancies
prenames12311644pr__ena_mes
prentices131111904pr__entices
presences132113794pr__esences
presentences1655694presentences
pretences132312614pr__etences
prevalences1845094prevalences
preventives1945724preventives
proenzymes2652104pro_enzymes
profanes132311574pro__fan_es
progenies12314124proge__nies
proletaries1348454proletaries
promenade1485694promena_de_
promenaded1683634promena_ded
promenader1583494promena_der
promenaders16102584promenaders
prominence1644924prominence_
pronates10418374pro__na_tes
pronenesses1379264pronenesses
pronounces1454994pro_nounces
propanes122415824pro__pan_es
propenes122816514prope__n_es
proteans102811544prote_an__s
proteases112110834prote_a_ses
proteinases1344524proteina_ses
protonates12411694protona_tes
protuberances1961264protuberances
provender1544894prove__nder
provenders1644274proven_ders
providence1854094providence_
province1546924prov__ince_
provolones1544644provolon_es
prudences1446684prude__nces
purtenance1454054purtenance_
purveyance2052374purveyance_
refinances15107134_refinances
relevances1596114_relevances
repentances1556114_repentances
resonances1246874_resonances
revenants1246174_revenan_ts
reverences1579174_reverences
romances12310794_ro__mances
ropedancer15132524_ropedancer
ropedancers16101744_ropedancers
rotenones956344_rotenon_es
severances1546784_severances
sonances10310264_so__nances
sustenances1353624sustenances
tolerances1245994_tolerances

Search took 10 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 Filter1786911488190.406440125.6
2DLD Change Limit1488191009.37615872.3
3Display Results1001000.0462173.9
 (SQL Overall)1786911009.82818181.8
 
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.