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

134 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
vitamers133468(None) 
vitamer1235471vitamer_
metamers1249622metamers
tamers84224032__tamers
vintagers13123902vintagers
vitamins1347082vitamins
aimers84621913ai__mers
bilayers13296923bilayers
biters83925243bit__ers
bitters94920363bit_ters
bitumens1243523bitumens
blamers115314213_blamers
citadels1142843citadels
citators10310253citators
citers85022983cit__ers
cithers124315773cit_hers
creamers124111313creamers
defamers14258523defamers
dialers83614303di_alers
diapers104713913di_apers
dilaters92513063dilaters
dimers94321093di__mers
dimmers123811563di_mmers
disarmers1246943disarmers
ditchers143610363ditchers
dithers114016153dit_hers
dreamers11369003dreamers
filmers124211293fi_lmers
firmers124711443fi_rmers
fitters104517753fit_ters
flamers124616363_flamers
foamers123812103_foamers
framers125113823_framers
gamers94420833__gamers
gleamers11306563gleamers
hitchers16379993hitchers
hitters104717593hit_ters
imagers10107763_imagers
isomers9310043_isomers
jitters144314473jit_ters
kiters105218593kit__ers
limmers113413083li_mmers
liters65429883lit__ers
litters73422573lit_ters
metamer1139613metamer_
metamere1257353metamere
metameres1347453metameres
mimers105520183mi__mers
misavers1348063misavers
mistakers15117083mistakers
miterers10219683miterers
miters84328783mit__ers
mithers123516733mit_hers
namers84517333__namers
niters64624213nit__ers
patamars1246843patamars
pitchers153211483pitchers
pitiers93812653pit_iers
reamers94221083_reamers
retakers123511133retakers
rimers84522553ri__mers
rimmers113812883ri_mmers
ritters74020623rit_ters
roamers93713463_roamers
seamers94719433_seamers
simmers113314613si_mmers
sitars65417593sita__rs
sitters74221553sit_ters
stagers84116673_stagers
stamens93411483_stamens
stammers123611523_stammers
stampers124211603_stampers
starers74522313_starers
staters73922343_staters
stayers103813633_stayers
steamers103410873steamers
tabers84621573__tabers
takers103923743__takers
talers64628143__talers
tamer75230103__tamer_
tames75242013__tame_s
tampers113516743__tampers
tapers84025813__tapers
taters64932203__taters
tawers94118603__tawers
taxers134015283__taxers
tetramers1146463tetramers
timers84420993__timers
titaness836723titaness
titers64526413tit__ers
titfers10318933tit_fers
tithers104216733tit_hers
titters74219623tit_ters
vampers143111623v__ampers
vealers103214293v_ealers
venomers1336703venomers
vetivers1435163vetivers
vetoers10359473vet_oers
vetters104016323vet_ters
viatores11257693viatores
viators102712023vi_ators
vicars11712263vica__rs
victualers1552063victualers
viers85621953vi___ers
viewers1337173vi_ewers
vilayets1443073vilayets
villagers13296153villagers
vintager12104823vintager_
vintages12118273vintage_s
vintners1134573vintners
violaters1245963violaters
vipers114914533vi__pers
visages1138693visage_s
visiters1137413visiters
vistaless1254573vistaless
vitae84217633vita_e__
vitalizers2244723vitalizers
vitalness1245413vitalness
vitals94514303vita__ls
vitamin1237423vitam_in
vitamine1347373vitamine
vitamines1446553vitamines
vitiates112311433vitiate_s
vitiators1246923vitiators
vittles103211113vittle_s
vivaces1536413vivace_s
vivers124717363vi__vers
viziers19336203vi_ziers
vomers115614943v__omers
votaress1144223votaress
voters95017443vot__ers
voyagers1532813voyagers
withers134417753wit_hers
zithers193911973zit_hers

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 Filter1786911461620.436409841.7
2DLD Change Limit1461621346.79621507.1
3Display Results1341340.0632127.0
 (SQL Overall)1786911347.29524495.0
 
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.