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

75 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
unvarnished185228(None) 
ungarnished1652351ungarnished
untarnished1553081untarnished
revarnished1852552revarnished
unfurnished1852232unfurnished
varnished16195602__varnished
evanished1644323_eva_nished
garnished14196143__garnished
revarnishes1742793revarnishes
tarnished13196063__tarnished
unfinished1763113un_finished
unharnessed1553403unharnessed
unpunished1642523un_punished
unravished1742773unra_vished
unvaried1239683unvar_i__ed
vanished15207743__va_nished
varnisher15195403__varnisher
varnishes15207913__varnishes
banished14189064__ba_nished
burnished1544924__burnished
enravished1742194enra_vished
evanishes1545604_eva_nishes
furnished1644584__furnished
garnishee13185764__garnishee
garnisheed15193134__garnisheed
garnisher13195854__garnisher
garnishes13198814__garnishes
nourished1374604_nour_ished
overfished2045674_overfished
planished1566124_pla_nished
refurnished18102744refurnished
revarnish1543934revarnish__
spearfished2052104spearfished
tarnishes12188894__tarnishes
tovarishes1643354tovar_ishes
unabashed1544104un_a_bashed
unadvised1443284un_advis_ed
unarched14128554un_ar__ched
unaroused1046524un_arous_ed
unassisted1143834un_assisted
unblemished1951714unblemished
unbranched1843534unbran_ched
unbruised1244764un_bruis_ed
unbrushed1544434un_br_ushed
uncashed14299764unca___shed
uncrushed1545024un_cr_ushed
undiminished1961464undiminished
unearned9310064unearn___ed
unearthed1345574unear__thed
unenriched1642564unenr_iched
unfished15218294un___fished
unharnesses1445434unharnesses
unharried1344764unharri__ed
unharvested1852114unharvested
unionised1046534un_ionis_ed
unlashed12289184unla___shed
unmagnified1852074unmagnified
unmannish1443364unmannish__
unmarried1244584unmarri__ed
unmortised1343994unmortis_ed
unpolished1643434un_polished
unpublished1952084unpublished
unraised91811884un__rais_ed
unrinsed938384un__rins_ed
unrushed12247574un__r_ushed
unversed122310434unver__s_ed
unwarned1238454unwarn___ed
unwashed15288484unwa___shed
unwished15237834un___wished
urbanised1295124urba_nis_ed
vanisher14167454__va_nisher
vanishes141610754__va_nishes
varnish13169534__varnish__
varnishers16174344__varnishers
varnishy17163404__varnish_y

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 Filter1786911488190.1561145455.1
2DLD Change Limit148819758.37617767.3
3Display Results75750.0302500.0
 (SQL Overall)178691758.56220870.2
 
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.