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

171 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
shive11442342(None) 
chive135117621chive
hive106029681_hive
shave114425891shave
shine85533091shine
shire84727131shire
shiv105721171shiv_
shiva115915001shiva
shiver124517371shiver
shives124921411shives
shivs115018801shivs
shove114421041shove
shrive125216951shrive
skive124614121skive
swive115316191swive
alive85722512alive
chide115321022chide
chile105626892chile
chime125322592chime
chine105231722chine
chives144317592chives
chivy164810362chivy
dive85634782_dive
drive95318002drive
five107629752_five
give85829362_give
have106137072_have
hide85134652_hide
hie67652712_hi_e
hike116830402_hike
hire75538972_hire
hived125217912_hived
hives116925512_hives
hove107132222_hove
jive146123602_jive
live76541002_live
naive85116212naive
ogive9379092ogive
olive84817152olive
reive85522942reive
rive75537732_rive
saice75424052saice
salve85022132salve
save75741362s_ave
scrive115414942scrive
seine55732872seine
seise54727852seise
seize143819502seize
serve85425962serve
shade95125582shade
shake124726402shake
shale85332832shale
shame105726702shame
shape105125112shape
share86437082share
shaved135118382shaved
shaven124213302shaven
shaver123718912shaver
shaves125224932shaves
shavie124312422shavie
she66837692sh__e
sheave124514002sheave
sheeve123412842sheeve
shelve124012762shelve
shied96125492shied
shiel811023772shiel
shier85428942shier
shies86136552shies
shift114225142shift
shikse1386072shikse
shill85325332shill
shily115222012shily
shim95827862shi_m
shims104422552shims
shin75634312shi_n
shined104620782shined
shiner93820872shiner
shines95028912shines
shins85131042shins
shiny115122142shiny
ship95228242shi_p
ships105123772ships
shires95225572shires
shirk124817842shirk
shirr84716922shirr
shirt84533902shirt
shist84829612shist
shit76745942shi_t
shits84731172shits
shivah15488542shivah
shivas124512412shivas
shivers133714832shivers
shivery16317022shivery
shoe75933442sh_oe
shone83725982shone
shore85432652shore
shote85526102shote
shoved134214282shoved
shovel124611322shovel
shover124515992shover
shoves124919422shoves
shrieve13417682shrieve
shrike134513242shrike
shrine94920052shrine
shrived144712182shrived
shrivel13479402shrivel
shriven13379652shriven
shriver134712192shriver
shrives134416172shrives
shrove125412232shrove
shute84520352shute
sice65545602s_ice
side55444502s_ide
sieve84918842sieve
sike87138792s_ike
sine46560632s_ine
sipe67341052s_ipe
sire46150422s_ire
site47052422s_ite
siver85728612s_iver
size135630972s_ize
skite95120062skite
skived14429892skived
skiver134612102skiver
skives134113942skives
slave84224032slave
slice74925822slice
slide64725422slide
slieve9359272slieve
slime74925752slime
slipe75626132slipe
sliver94116592sliver
smile74823922smile
smite75224872smite
snide64318732snide
snipe75320572snipe
snivel9368852snivel
soave84219052soave
solve85618942solve
spice95528812spice
spike114922842spike
spile75230082spile
spine76534422spine
spire75828692spire
spite75430662spite
spiv95917792spiv_
spivs105114242spivs
stave85324992stave
stile54931572stile
stime76521802stime
stipe76523372stipe
stiver93915732stiver
stove85220252stove
strive95020962strive
suave83519872suave
suite54829562suite
swine85625302swine
swipe105217082swipe
swived133610632swived
swivel12369322swivel
swives123915182swives
swivet123615472swivet
thieve1235962thieve
thine85026862thine
thrive125313222thrive
vive105426632_vive
waive114214602waive
while115418692while
whine116022812whine
white114920302white
wive105931762_wive

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001711.59333772.8
3Display Results1711710.0463717.4
 (SQL Overall)1786911711.93592346.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.