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

206 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
shave11442589(None) 
have106137071_have
save75741361s_ave
shade95125581shade
shake124726401shake
shale85332831shale
shame105726701shame
shape105125111shape
share86437081share
shaved135118381shaved
shaven124213301shaven
shaver123718911shaver
shaves125224931shaves
shavie124312411shavie
sheave124514001sheave
shive114423421shive
shove114421031shove
slave84224031slave
soave84219051soave
stave85324991stave
suave83519871suave
agave95314032agave
ave67748702__ave
behave14209012behave
brave104925502brave
cave95941262_cave
chafe135117352chafe
chape125221142chape
chare105231982chare
chase105127122chase
chive135117622chive
clave105420152clave
crave105626312crave
deave95022332deave
drave95219272drave
eave75733582_eave
fave105532962_fave
gave84634052_gave
grave94624872grave
hade85440192_hade
hae67364002_ha_e
hake115637842_hake
hale76052832_hale
halve114818922_halve
hame97043132_hame
hare76255732_hare
hate78450172_hate
haven114718532_haven
haver115124462_haver
haves116034872_haves
haze164833392_haze
heave114521812heave
hive106029672_hive
hove107132222_hove
knave12389462knave
lave75642142_lave
leave84723722leave
nave75732312_nave
pave96133892_pave
phage115113672phage
phase104617212phase
rave75542092_rave
reave84528022reave
reshave1338602reshave
sabe66140572s_abe
sade55544472s_ade
sae38365182s_a_e
safe75930952s_afe
sage55044592s_age
sake85244962s_ake
sale44959702s_ale
salve85022132salve
same65245642s_ame
sane45954332s_ane
sate45556102s_ate
saved95127112s_aved
saver84831252s_aver
saves85838632s_aves
scale74629142scale
scape96921842scape
scare75334462scare
schav1338312schav_
schavs1436492schavs
serve85425962serve
sha69837782sha__
shack145321752shack
shad86230912sha_d
shaded114518872shaded
shader104218762shader
shades105924532shades
shads95124482shads
shady125416512shady
shaft115725252shaft
shag86430562sha_g
shags95123862shags
shah105627782sha_h
shahs115919512shahs
shaken134113612shaken
shaker134319462shaker
shakes135024592shakes
shako125516082shako
shaky154616842shaky
shaled105023952shaled
shales94731252shales
shaley123714992shaley
shall85024052shall
shalt85534482shalt
shaly114322862shaly
sham96436352sha_m
shamed125120212shamed
shames114726222shames
shams105829412shams
shank125422192shank
shaped125020102shaped
shapen114414652shapen
shaper114119932shaper
shapes115124942shapes
shard96125962shard
shared105829062shared
sharer95025482sharer
shares95236412shares
shark126225022shark
sharn84823702sharn
sharp104922532sharp
shat76456592sha_t
shaul85418102shaul
shavers134115092shavers
shavies134213202shavies
shaw108132552sha_w
shawed134817232shawed
shawl116217572shawl
shawm135316142shawm
shawn116417612shawn
shaws116226262shaws
shay107133342sha_y
shays116021432shays
she66837692sh__e
sheaved143411632sheaved
sheaves134412972sheaves
sheeve123412842sheeve
shelve124012762shelve
shine85533092shine
shire84727132shire
shiv105721162shiv_
shiva115915002shiva
shiver124517372shiver
shives124921412shives
shivs115018802shivs
shoe75933432sh_oe
shone83725972shone
shore85432642shore
shote85526082shote
shoved134214272shoved
shovel124611312shovel
shover124515982shover
shoves124919412shoves
shrive125216952shrive
shrove125412222shrove
shute84520342shute
sieve84918842sieve
skate94721542skate
skive124614112skive
slake93724052slake
slate55438282slate
slaved104017042slaved
slaver94419612slaver
slaves95023022slaves
slavey124011802slavey
sleave94714152sleave
smaze165012932smaze
snake94821112snake
snare54429982snare
soaves94218672soaves
solve85618942solve
space95325672space
spade84423322spade
spae65034322spa_e
spake114322742spake
spale74929212spale
spare75135562spare
spate74731582spate
spavie113611382spavie
stade64825302stade
stage65330192stage
stake95927532stake
stale55637102stale
stane55933002stane
stare54440262stare
starve94613742starve
state56237332state
staved103918052staved
staves94525192staves
stove85220252stove
suaver93014232suaver
swage94919562swage
swale85221592swale
sware85828212sware
swive115316192swive
thae76825562tha_e
thane86122532thane
thrave126010272thrave
trave85223032trave
wave105234732_wave
weave115218532weave
whale115517432whale
wharve15456202wharve

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.1101624463.6
2DLD Change Limit538002061.68631909.8
3Display Results2062060.0633269.8
 (SQL Overall)1786912061.85996122.1
 
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.