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

389 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
sherpa113809(None) 
sherpas1238091sherpas
herma105318882_herma
sera46141392s_er_a
sharia93116722sharia
sharp104922532sharp_
sharps115516082sharps
sharpy145211032sharpy
shea76031572she__a
sheep105321522sheep_
sheila969842sheila
shelta93111782shelta
sherd96321152sher_d
sherds105614722sherds
sherif122915232sherif
sherry124510412sherry
sierra637312sierra
sterna63712762sterna
arepa75615563are_pa
asteria7316173asteria
ceria75125353_ceria
charka154011703charka
charpai1436623charpai
cheap126915943cheap_
cheapo134810083cheapo
cheaps134613683cheaps
cheep125416503cheep_
cheeps135312913cheeps
chela103916803che_la
cherry144810763cherry
chert105232103cher_t
cherts115617233cherts
cherty144612473cherty
cherub1337263cherub
chirp124717163chirp_
chirps135414003chirps
chirpy16498913chirpy
chorea115216083chorea
chuppa1543973chuppa
derma84918513_derma
dharma1276103dharma
dharna1055263dharna
dhurna1043563dhurna
era35741503__er_a
feria85922713_feria
gherao1036753gherao
harp96134283_harp_
harps105926863_harps
harpy136418203_harpy
heap96432893_heap_
heaps105223223_heaps
heapy135914983_heapy
help95328923_help_
helps105219343_helps
hemp115725623_hemp_
hemps126917333_hemps
hempy154912763_hempy
henna84414043_henna
hep86644143_he_p_
her66547813_her__
herb94730963_her_b
herbal112513493_herbal
herbs105520503_herbs
herby134715313_herby
herd84933063_her_d
herds96424683_herds
here76447103_her_e
hereat93527413_hereat
heres86245903_heres
herl75834553_her_l
herls85226433_herls
herm95636153_her_m
hermae115314473_hermae
hermai118912843_hermai
herms105626433_herms
hern76134893_her_n
hernia9312293_hernia
herns84825583_herns
hero74635783_her_o
heron85025503_heron
heros84930863_heros
herpes115517323_herpes
herry114922473_herry
hers75844873_her_s
hertz174919033_hertz
hora76136553_hor_a
kheda1346533khe_da
opera7313573oper_a
overpay15228263overpay
perea75026443_perea
perp89029893_perp_
perps95521483_perps
rhea75017433rhe__a
sabra75317853sabr_a
sacra74516993sacr_a
salpa75018353s_alpa
satrap86212553satrap
scarp95724103scarp_
scarph13429603scarph
scarps104718603scarps
scena74815783sce_na
schema1388373sche_ma
scherzi2143573scherzi
scherzo2153933scherzo
sclera838883scler_a
scoria8513483scoria
scrap97120403s_crap
sea36161293s_e__a
secpar1037923s_ecpar
seep66540343s_eep_
seeps74828753s_eeps
seepy104717973s_eepy
seer45547043seer__
seers55136383seer_s
selva83014273s_elva
senna54617983s_enna
sensa54117473s_ensa
sepal77723003s_e_pal
sepia75318673s_epia
sept65844363s_e_pt
septa75518083s_epta
ser36752403s_er__
serac75925203s_erac
serai56830163s_erai
seral56336383s_eral
serape84818413s_erape
seraph114011163s_eraph
serdab937833s_erdab
sere46153473s_er_e
sered65737293s_ered
serer55935503s_erer
seres55448893s_eres
serf76340113s_er_f
serfs84922013s_erfs
serge64727463s_erge
serial64625853s_erial
serif84132133s_erif
serin55434443s_erin
serosa6313023s_erosa
serow86720443s_erow
serry84824123s_erry
sers45746653s_er_s
serum75223473s_erum
serval93913413s_erval
serve85425963s_erve
servo84516683s_ervo
seta45637313s_e_ta
sha69837783sh___a
shape105125113sh_ape
shard96125963shar_d
shards104319173shards
share86437083shar_e
shared105829063shared
sharer95025483sharer
shares95236413shares
shariah132210533shariah
sharias102516003sharias
sharif122917113sharif
shark126225023shar_k
sharks135019723sharks
sharn84823703shar_n
sharns95516983sharns
sharny124711833sharny
sharped134112043sharped
sharpen12389723sharpen
sharper124312703sharper
sharpie1238383sharpie
sharply15406833sharply
she66837693she___
sheaf115424123she_af
sheafs124912883sheafs
sheal84927703she_al
sheals94420643sheals
shear85424833she_ar
sheared114516003sheared
shearer104414683shearer
shears93820903shears
sheas86331793she_as
sheath12412883sheath
sheave124514003sheave
shebean1235763shebean
shed86536153she__d
sheds96122703she_ds
sheen85023313she_en
sheens95116993sheens
sheeny124912193sheeny
sheepman1543853sheepman
sheer84726893she_er
sheered113515453sheered
sheerer103813843sheerer
sheerly13337703sheerly
sheers94322403sheers
sheesh1237813sheesh
sheet84836953she_et
sheets93918493sheets
sheeve123412843sheeve
sheik122514653she_ik
sheikh16206993sheikh
sheiks132510013sheiks
sheilas1059403sheilas
sheitan1036563sheitan
shekel1338383shekel
shelf115221113she_lf
shell84424123she_ll
shellac1236693shellac
shells94319523shells
shelly124414463shelly
sheltas10279663sheltas
shelty124011543shelty
shelve124012763shelve
shelvy15377863shelvy
shend94719973she_nd
shends105313773shends
shent85933493she_nt
sheol84318363she_ol
sheols94614153sheols
sheqel1846523sheqel
sherbet12311383sherbet
shereef1337743shereef
sheriff16287693sheriff
sherifs13299683sherifs
sheroot10414373sheroot
sherris10168793sherris
shes75734353she__s
sheuch14267043sheuch
sheugh13295883sheugh
shew108030763she__w
shewed134716183shewed
shewer124515103shewer
shewn115715703she_wn
shews115924713she_ws
shier85428943shier__
shiers94921753shier_s
shiksa1394653shiksa
ship95228233sh_ip_
ships105123773sh_ips
shire84727133shir_e
shires95225573shires
shirk124817843shir_k
shirks134814123shirks
shirr84716923shir_r
shirrs94413173shirrs
shirt84533893shir_t
shirts94918333shirts
shirty124312553shirty
shiva115915003sh_iva
shlep104914833shlep_
shlepp13366193shlepp
shlepps14394833shlepps
shleps114710333shleps
shnaps1148083shnaps
shoepac1444003shoepac
shoer84722153shoer__
shoers94518323shoer_s
shop95629833sh_op_
shoppe133110313shoppe
shops104222893sh_ops
shoran94016033shoran
shore85432643shor_e
shored105723643shored
shores94830403shores
shorl84720243shor_l
shorls94516193shorls
shorn85722173shor_n
short85040523shor_t
shortia1048173shortia
shorts95321733shorts
shorty124313193shorty
shred98125613sh_red
shreds105613053shreds
shrew119720163sh_rew
shrewd136810773shrewd
shrews129313913shrews
shri76021693sh_r_i
shris84221443sh_ris
shrub104814893sh_rub
shrug94512513sh_rug
shwa106014963sh__wa
shyer114714783shyer__
shyers124712203shyer_s
sienna647193sienna
sierran737193sierran
sierras737863sierras
siesta639503siesta
sirra54416323s_irra
skelp114211423skelp_
skelps12407923skelps
skep105219353ske_p_
skeps115614253ske_ps
skerry13356103skerry
sleep74920183sleep_
sleeps83913323sleeps
sleepy11479413sleepy
slept75728103sle_pt
slurp74014983slurp_
slurps84410003slurps
smegma1134113smegma
smerk115412723smer_k
smerks12449713smerks
sneap75514823sneap_
sneaps84510863sneaps
sora45746913s_or_a
sorta57125413s_orta
spa55730813s___pa
sperm93216013sper_m
sperms102512603sperms
spheral1238423spheral
sphere113313653spher_e
sphered133512313sphered
spheres123114353spheres
spheric14510073spheric
sphery14318883spher_y
spirea84015633spirea
steep76020703steep_
steeps85215193steeps
stela54019043ste_la
stella63612973stella
stemma10328133stemma
step67126293ste_p_
steppe10319873steppe
steps76619883ste_ps
stere55328543ster_e
stereo65317913stereo
steres63929533steres
steric8317063steric
stern55319123ster_n
sternal73411903sternal
sterns64616753sterns
sterol6613323sterol
stewpan1234193stewpan
sthenia1058503sthenia
stirp76815503stirp_
stirps85011813stirps
strap77925263s_trap
strep77120853strep_
streps86218063streps
stria55723203s_tria
stupa74112313s_tupa
suer45334033suer__
suers55128483suer_s
supra73614253supr_a
sura45740293s_ur_a
surra55521343s_urra
sutra54217933sutr_a
sweep104715723sweep_
sweeps114110513sweeps
sweepy14447453sweepy
swept105720603swe_pt
swerve1256293swerve
tepa66021683_te_pa
terga63315643_terga
terra54419653_terra
theca103311453the_ca
therapy1536613therapy
there87527393ther_e
thereat104315243thereat
theres96525473theres
theriac1239143theriac
therian10311293therian
therm106018023ther_m
thermae125310493thermae
thermal125010963thermal
therme115814993therme
therms115914873therms
thesp105410313thesp_
thesps11448263thesps
theta83414573the_ta
thoria93012883thoria
thorp104414263thorp_
thorpe113610093thorpe
thorps113610893thorps
threap11569663threap
twerp10398413twerp_
twerps11345153twerps
usher84517763usher__
ushered1139153ushered
ushers94415533usher_s
vera76828843_ver_a
wheep136214353wheep_
wheeps14439953wheeps
whelp136012093whelp_
whelps14437843whelps
where117019423wher_e
whereas13448903whereas
whereat134311923whereat
wheres125917433wheres
wherry15477333wherry
wherve15568113wherve
yerba101010763_yerba

Search took 6 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.1431249587.4
2DLD Change Limit1127163895.12322002.0
3Display Results3893890.1402778.6
 (SQL Overall)1786913895.40633054.2
 
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.