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

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

123 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
slivers10411525(None) 
clivers123411751clivers
livers94927821_livers
shivers133714831shivers
silvers104714041silvers
sivers95324151s_ivers
skivers14409701skivers
slavers103716501slavers
slicers94114921slicers
sliders83515221sliders
sliver94116591sliver_
stivers103613541stivers
aivers94822322_aivers
aliners74717722aliners
clavers124314902clavers
clovers125114662clovers
delivers123310752delivers
divers105024962_divers
drivers114412792drivers
elvers93814982el_vers
fivers124420922_fivers
fliers94417192fli_ers
flivvers1733112flivvers
givers104817712_givers
gliders94811842gliders
glovers114310882glovers
jivers164515642_jivers
lavers94526362_lavers
levers94621322_levers
libers84721442_libers
liers55130402_li_ers
lifers95617842_lifers
ligers75022042_ligers
likers104620912_likers
liners65428852_liners
liters65429882_liters
livens94314892_livens
liver85132962_liver_
livery124910902_livery
lives86133192_live_s
liviers104211072_liviers
livres94311862_livres
livyers13365902_livyers
lovers94223432_lovers
olives94313952olive_s
pliers84715152pli_ers
plovers123611832plovers
quivers19298752quivers
reivers105117082reivers
rivers94626542_rivers
sailers73822322sailers
salvers103916002salvers
savers93825922s_avers
seiners74219272seiners
seisers73816392seisers
seizers164112502seizers
servers103214832servers
severs94121122s_evers
shavers134115092shavers
shiers94921752shi_ers
shiners104015942shiners
shiver124517372shiver_
shivery16317022shivery
shives124921412shive_s
shovers134613002shovers
shrivers14419102shrivers
sillers73822102sillers
silver93815812silver_
silvern10347142silvern
silvery13328092silvery
siver85728612s_iver_
sizers155215812s_izers
skiers104713702ski_ers
skiver134612102skiver_
skives134113942skive_s
slakers114115752slakers
slaters73123732slaters
slaver94419612slaver_
slavery13407892slavery
slaves95023022slave_s
slaveys13415202slaveys
slayers104513322slayers
slicer84117602slicer_
slices84022852slice_s
slickers143112552slickers
slider73918362slider_
slides73922182slide_s
slier54827242sli_er_
slieves10378962slieves
slimes84722042slime_s
slimmers12369632slimmers
slingers93712682slingers
slipes84921412slipe_s
slipovers1443462slipovers
slippers123711232slippers
slithers114212952slithers
slitters84014132slitters
slivered12218102slivered
sliverer11237632sliverer
sliverers12196362sliverers
slopers94213092slopers
slovens10316572slovens
smilers94113852smilers
smiters93414362smiters
snipers93311772snipers
snivels10336902snivels
solvers104414252solvers
spicers113815552spicers
spiders103914412spiders
spiers84421742spi_ers
spikers135311992spikers
splicers12338112splicers
stiver93915732stiver_
stovers103713732stovers
strivers113911842strivers
stuivers11406672stuivers
suiters73618882suiters
swivels13396772swivels
swives123915182swive_s
swivets13436962swivets
vivers124717362_vivers
waivers133410052waivers
wivers125320802_wivers

Search took 4 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 Filter1786911076710.356501941.0
2DLD Change Limit1076711233.47031029.1
3Display Results1231230.0462673.9
 (SQL Overall)1786911233.87246149.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.