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

209 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
shelf115221111shel_f
shelve124012761shelve
shelvy15377861shelvy
helve115018092_helve
self75138292s_el_f
selva83014272s_elva
sheaf115424122she_af
sheave124514002sheave
sheeve123412842sheeve
shell84424122shel_l
shells94319522shells
shelly124414472shelly
shelta93111792shelta
shelty124011552shelty
shelved14379932shelved
shelver134211062shelver
shelves134112092shelves
sherif122915242sherif
chef125125623che__f
chela103916803chel_a
chelae113614603chelae
chelas113817203chelas
chevy16479993che_vy
delf85436573_del_f
delve96018263_delve
elf66138523__el_f
half106238453_hal_f
halva115414433_halva
halve114818923_halve
heave114521813_heave
heavy144814183_heavy
held85330403_hel_d
helio85321193_helio
helix154413013_helix
hell75637893_hel_l
hello86522983_hello
hells85032043_hells
helm95530023_hel_m
helms105619463_helms
helo75332853_hel_o
helos84928063_helos
helot85332683_helot
help95328923_hel_p
helps105219343_helps
helved134313703_helved
helves124316063_helves
khalif1657833khalif
pelf97031453_pel_f
salve85022133s_alve
salvo84415643s_alvo
seel45042983seel__
seeled73922093seeled
seels55632823seel_s
seely84522633seel_y
seif75638733s_e_if
sel38253323s_el__
selah8319613s_elah
selfs85220243s_elfs
sell45840613s_el_l
selle54428313s_elle
sells55134433s_ells
sels46345983s_el_s
selvas93812913s_elvas
selves94119613s_elves
serf76340113s_e_rf
serif84132133s_erif
serve85425963s_erve
servo84516683s_ervo
shaduf1337063shaduf
shale85332833shal_e
shaled105023953shaled
shales94731253shales
shaley123714993shaley
shall85024053shal_l
shalom11810923shalom
shalt85534493shal_t
shaly114322863shal_y
sharif122917123sharif
shave114425893sh_ave
she66837693she___
shea76031573she__a
sheafs124912883sheafs
sheal84927703she_al
sheals94420643sheals
shear85424833she_ar
shears93820903shears
sheas86331793she_as
sheath12412893sheath
sheaved143411633sheaved
sheaves134412973sheaves
shed86536153she__d
sheds96122703she_ds
sheen85023313she_en
sheens95116993sheens
sheeny124912193sheeny
sheep105321523she_ep
sheer84726893she_er
sheers94322403sheers
sheesh1237813sheesh
sheet84836963she_et
sheets93918503sheets
sheeves133911953sheeves
sheik122514663she_ik
sheikh16206993sheikh
sheiks132510013sheiks
sheila969843sheila
sheilas1059403sheilas
shekel1338383shekel
shelfful1742423shelfful
shellac1236693shellac
shelled113815083shelled
sheller103515883sheller
sheltas10279673sheltas
shelter103214963shelter
sheltie10109913sheltie
shelvers14388813shelvers
shelvier1464913shelvier
shelving15278173shelving
shend94719973she_nd
shends105313773shends
shent85933503she_nt
sheol84318373she_ol
sheols94614163sheols
sheqel1846523sheqel
sherd96321153she_rd
sherds105614723sherds
shereef1337743shereef
sheriff16287693sheriff
sherifs13299683sherifs
sherpa1138093sherpa
sherry124510413sherry
shes75734353she__s
sheuch14267043sheuch
sheugh13295883sheugh
shew108030763she__w
shewed134716183shewed
shewer124515113shewer
shewn115715703she_wn
shews115924713she_ws
shiel811023773shiel__
shield106212973shiel_d
shields11538043shields
shiels95418923shiel_s
shill85325333shil_l
shills94519613shills
shily115222013shil_y
shiv105721173sh_iv_
shiva115915003sh_iva
shive114423423sh_ive
shivs115018803sh_ivs
shlep104914833sh_lep
shlepp13366193shlepp
shleps114710333shleps
shlub105411743sh_lub
sholom11910113sholom
shove114421043sh_ove
shrive125216953shrive
shroff1538503shroff
shrove125412233shrove
shul75823153shul__
shuln84713113shul_n
shuls85319713shul_s
shyly144811573shyl_y
sieve84918843sie_ve
silva82714023s_ilva
skell94915833skel_l
skells105013783skells
skelm114211293skel_m
skelms12368023skelms
skelp114211423skel_p
skelps12407923skelps
sleave94714153sleave
sleeve93411593sleeve
smell74916233smel_l
smells83914743smells
smelly114110363smelly
smelt74726783smel_t
smelts85412773smelts
snell54517303snel_l
snells64614203snells
solve85618943s_olve
spell75020303spel_l
spells84617683spells
spelt75430193spel_t
spelts84614643spelts
speltz174010123speltz
steeve93710903steeve
stela54019043stel_a
stelae63716483stelae
stelai63912563stelai
stelar64013863stelar
stele55026843stel_e
steles63725663steles
stelic8313083stelic
stella63612973stella
svelte9319753svelte
swell84815983swel_l
swells93913983swells
swerve1256293swerve
sylva11268443s_ylva
twelve1234163twelve
whelk154311063whel_k
whelks16367323whelks
whelky19314973whelky
whelm134611983whel_m
whelms14377573whelms
whelp136012093whel_p
whelps14437843whelps
wherve15568113wherve

Search took 7 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 Filter1786911127160.783228213.3
2DLD Change Limit1127162095.45320670.5
3Display Results2092090.0633317.5
 (SQL Overall)1786912096.29928368.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.