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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
revarnishes174279(None) 
revarnished1852551revarnished
evanishes1545602_eva_nishes
refurnishes17102992refurnishes
revarnish1543932revarnish__
varnishes15207912__varnishes
evanished1644323_eva_nished
garnishes13198813__garnishes
refinishes1644693re_finishes
refurbishes19112613refurbishes
refurnished18102743refurnished
replenishes1653053replenishes
revanches1746253reva_n_ches
revarnishing1982183revarnishing
tarnishes12188893__tarnishes
tovarishes1643353tovar_ishes
unvarnished1852283unvarnished
vanishes141610753__va_nishes
varnished16195603__varnished
varnisher15195403__varnisher
varnishers16174343__varnishers
banishes131812464__ba_nishes
boarfishes1844974_boarfishes
burnishes1436644__burnishes
danishes121710494__da_nishes
dealfishes1744194de_alfishes
dearnesses1139584de_arnesses
dervishes1644934de__rvishes
devilfishes2151994devilfishes
enravishes1642154_enravishes
eternises9119454_eternis_es
evanesces1463184_eva_nesces
evanish1337654_eva_nish__
furnishes1536234__furnishes
garfishes16167084__garfishes
garnished14196144__garnished
garnishee13185764__garnishee
garnishees14184174__garnishees
garnisher13195854__garnisher
garnishers14174864__garnishers
headfishes2044414he_adfishes
marishes13512554__mar_ishes
nearnesses1039104ne_arnesses
oarfishes15156954__oarfishes
overfishes1947014_overfishes
parishes13314754__par_ishes
pearlashes1543264pe_arlashes
perishes13313754pe__r_ishes
planishes14138524_pla_nishes
premonishes1843914pre_monishes
radishes1269464r__a_dishes
ratfishes1546104r__atfishes
ravishes1478044r__a_vishes
realises82420184re_a_lis_es
realnesses10310854re_alnesses
rearouses9310204re_arous_es
rebranches1745194rebran_ches
recarries1147864recarri__es
recognises1345534recognis_es
redfishes1645794re__dfishes
refinished1744084re_finished
refinisher1643374re_finisher
refinishers1752624re_finishers
refreshes1595954re_fr_eshes
refurbished20112374refurbished
refurbisher19132124refurbisher
refurbishers20101714refurbishers
refurnish1543854refurnish__
regalnesses1246194regalnesses
rehashes1436954reha___shes
relaunches1543444relaun_ches
relishes11311954re___lishes
remarriages1452204remarriages
remarries1147674remarri__es
reminisces1445254re_minisces
replenished1752454replenished
replenisher1652154replenisher
replenishers1751694replenishers
repolishes15105104re_polishes
reprises102615464re_pr_is_es
republishes1853134republishes
reraises8415644re__rais_es
rerises73525884re__r_is_es
revanche1645004reva_n_che_
reveries112518514rever_i__es
reverifies1645974rever_ifies
reverses112513514rever__s_es
reversibles1682854reversibles
revises104220534rev___is_es
rewashes1447034rewa___shes
romanises11311574roma_nis_es
spearfishes1953164spearfishes
starfishes1646154_starfishes
tarnished13196064__tarnished
tetanises979874teta_nis_es
tovariches1841944tovar_iches
ungarnished1652354ungarnished
untarnished1553084untarnished
vanished15207744__va_nished
vanisher14167454__va_nisher
vanishers15186614__va_nishers
varnish13169534__varnish__
varnishy17163404__varnish_y
weakfishes2343354we_akfishes
zebrafishes2851274zebrafishes

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.420425454.8
2DLD Change Limit1488191058.75317002.1
3Display Results1051050.0601750.0
 (SQL Overall)1786911059.23319353.5
 
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.