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

103 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
stivers10361354(None) 
shivers133714831shivers
sivers95324151s_ivers
skivers14409701skivers
slivers104115251slivers
stiver93915731stiver_
stovers103713731stovers
strivers113911841strivers
stuivers11406671stuivers
aivers94822322_aivers
clivers123411752clivers
divers105024962_divers
drivers114412792drivers
estovers1136452estovers
fivers124420922_fivers
givers104817712_givers
jivers164515642_jivers
livers94927822_livers
quivers19298752quivers
reivers105117082reivers
rivers94626542_rivers
sailers73822322sailers
salvers103916002salvers
savers93825922s_avers
seiners74219272seiners
seisers73816392seisers
seizers164112502seizers
servers103214832servers
severs94121122s_evers
shavers134115092shavers
shiers94921752shi_ers
shiners104015942shiners
shiver124517372shiver_
shivery16317022shivery
shives124921412shive_s
shovers134613002shovers
shrivers14419102shrivers
silvers104714042silvers
sitters74221552sitters
siver85728612s_iver_
sizers155215812s_izers
skiers104713702ski_ers
skiver134612102skiver_
skives134113942skive_s
slavers103716502slavers
slicers94114922slicers
sliders83515222sliders
sliver94116592sliver_
smilers94113852smilers
smiters93414362smiters
snipers93311772snipers
snivels10336902snivels
solvers104414252solvers
spicers113815552spicers
spiders103914412spiders
spiers84421742spi_ers
spikers135311992spikers
stagers84116672stagers
stainers83212172stainers
starers74522312starers
starvers11459642starvers
staters73922342staters
staves94525192stave_s
stayers103813632stayers
steers63820982st_eers
stickers142913032stickers
sties55132982sti_e_s
stiflers11238832stiflers
stiles64328772stile_s
stimes85920572stime_s
stingers94012742stingers
stinkers123111132stinkers
stinters83312752stinters
stipels9418952stipels
stipes84524052stipe_s
stirrers8266942stirrers
stirs55921622sti__rs
stokers114515182stokers
stoners74817952stoners
stopers94217372stopers
storers75018682storers
stover94115642stover_
stoves93818922stove_s
striders94412122striders
strikers123611292strikers
stripers103911592stripers
striver104315202striver_
strives104119372strive_s
stuiver10447082stuiver_
stylers10359352stylers
suiters73618882suiters
swivels13396772swivels
swives123915182swive_s
swivets13436962swivets
tiers55526522_ti_ers
tigers75616512_tigers
tilers63523502_tilers
timers84420992_timers
titers64526412_titers
vetivers1435162vetivers
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.360496363.9
2DLD Change Limit1076711033.12634443.7
3Display Results1031030.0303433.3
 (SQL Overall)1786911033.51650822.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.