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

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

200 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
selvage113655(None) 
salvage1138191salvage
selvaged1334341selvaged
selvages1236511selvages
meltage1037952meltage
pelage9515362pel_age
salvaged1335352salvaged
salvagee1246482salvagee
salvager1235592salvager
salvages1238122salvages
savage10410172s_avage
seepage1037542seepage
selva83014272selva__
selvas93812912selva_s
selvedge1342042selvedge
septage1078402septage
serfage1138402serfage
sewage10310732se_wage
silage72715302sil_age
silvae92811092silva_e
solvate102710212solvate
sullage859912sullage
sylvae12236862sylva_e
anlage72514223anl_age
beldame1237233beldame
bulkage1435703bulkage
cellae84915933cella_e
cleavage1442773cleavage
collage102813753collage
degage92711383de_gage
delate73827753del_ate
deleave1147723deleave
deluge8189403del_uge
delve96018263delv__e
elate55335883_el_ate
elevate101110373_elevate
eluate62315433_eluate
encage93713503_encage
engage82812103_engage
enrage72715073_enrage
escuage1035113escuage
evade938183_e_vade
fellate10313433fellate
foliage1147533foliage
fuselage1243553fusel_age
gavage1137193_gavage
gelate73421253gel_ate
helotage1245713helotage
helve115018093helv__e
herbage1337003herbage
keelage1236183keelage
lavage1038263_lavage
leafage1194573leafage
leakage1235003leakage
lovage1037353_lovage
melange1038363melange
meltages1148243meltages
menage93216543me_nage
message1037833message
metage93114453me_tage
milage93414123mil_age
mileage10299313mileage
millage103112743millage
nervate1039523nervate
peage84723563pe__age
peerage1089803peerage
pelages10714613pel_ages
peltate92013773peltate
peonage1048723peonage
pervade1337023pervade
pillage103412593pillage
plage84520403_pl_age
ravage1039303_ravage
reimage1037913reimage
relace83122153rel_ace
relate64033633rel_ate
release7312763release
restage83316183restage
rivage1038843_rivage
sage55044593s___age
salivate11310013salivate
salpae84614273salpa_e
salvable1338403salvable
salvagees1343673salvagees
salvagers1344693salvagers
salve85022133salv__e
sausage847193sausage
savaged1236993s_avaged
savager1137133s_avager
savages1139973s_avages
savate9313783s_avate
scalage103110533scalage
scutage1036333scutage
seabag938473seabag_
seabags1037483seabags
seaware1049623seaware
sedate73019803se_date
sedge75019953se__dge
seepages1137283seepages
selah8319613sel_a_h
selahs9313213sel_ahs
selenate81712523selenate
selfsame1342883selfsame
selkie102811693sel_kie
sellable101711823sellable
selle54428313sel__le
selvedged1541543selvedged
selvedges1442083selvedges
selves94119613selv_es
senate63725143se_nate
sensate7311883sensate
septages1168263septages
septate9511873septate
serape84818413se_rape
serfages1238233serfages
serge64727463se__rge
seriate73722473seriate
serrate73017533serrate
servable13310083servable
serval93913413serva_l
servals103410743servals
servant10313623servant
serve85425963serv__e
service1239083service
servile10310643servile
sesame8311013se_same
setae56026223se_ta_e
severe94016083se_vere
sewages1139753se_wages
sewerage1245513sewerage
shelve124012763shelv__e
signage937773signage
silages82514443sil_ages
silane62718053sil_ane
silva82714023silva__
silvan92810153silva_n
silvans10308323silvans
silvas92912183silva_s
sinkage1287263sinkage
slag55934353s_l_ag_
slags66525903s_l_ags
slake93724053s_l_ake
slate55438283s_l_ate
slave84224033s_l_ave
sleave94714153s_leave
sleaze152611863s_leaze
sledge85011283s_ledge
sludge84811943s_ludge
smallage1145183smallage
soakage1236103soakage
socage91012123s_ocage
soccage1236283soccage
soilage8169353soilage
solace83415823sol_ace
solate64526073sol_ate
solfege1144223solfege
solvable1337473solvable
solvated12237443solvated
solvates11249673solvates
solve85618943solv__e
spillage1146263spillage
spinage10289653spinage
splake1259783spl_ake
splodge1134103splodge
splurge1044753splurge
stage65330193s__tage
stealage946583stealage
steerage946833steerage
stelae63716483stel_a_e
stellate8310503stellate
storage8310473storage
stowage1136703stowage
stravage1245563stravage
sulcate9314423sulcate
sulfate10311653sulfate
sullages939973sullages
swage94919563s__wage
sylva11268443sylva__
sylvan12257363sylva_n
sylvans13235893sylvans
sylvas12288173sylva_s
sylvine13216543sylvine
sylvite13266353sylvite
tallage82712073tallage
teenage8108053teenage
telae54323293tel_a_e
tentage81010643tentage
tillage83111333tillage
tollage82610163tollage
ullage739043_ullage
valvate133710813valvate
velate93720143vel_ate
ventage11109623ventage
village113610823village
voltage1136863voltage
volvate13317993volvate
vulvae12438033vulva_e
vulvate13388323vulvate
webpage1543133webpage
welfare1335713welfare

Search took 8 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 Filter1786911340270.1701051123.5
2DLD Change Limit1340272007.53317792.0
3Display Results2002000.0762631.6
 (SQL Overall)1786912007.77922970.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.