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

427 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
scarph1342960(None) 
scarp95724101scarp_
scarphs14437411scarphs
scarps104718601scarps
caph116623292_ca_ph
carp85139812_carp_
carpi94319392_carpi
carps96932252_carps
escarp10449002escarp_
escarps11397372escarps
scalp95217982scalp_
scalps104315232scalps
scamp115717312scamp_
scampi12469102scampi
scamps125014172scamps
scape96921842sca_pe
scar66434202scar__
scarab10310062scarab
scarce104013632scarce
scare75334462scar_e
scared95227292scared
scarer84524602scarer
scares85033002scares
scarey115016982scarey
scarf105427142scar_f
scarfs114714682scarfs
scarped124314392scarped
scarper114814822scarper
scarphed1635432scarphed
scarry116311182scarry
scars75433532scar_s
scart76139772scar_t
scarts85321492scarts
scary105222592scar_y
scaup95515992scaup_
scaups105411932scaups
scorch13198092scorch
scrap97120402scrap_
scrape105917572scrape
scraps106017242scraps
search113312422search
seraph114011162seraph
sharp104922532sharp_
sharps115516082sharps
sharpy145211032sharpy
staph104314652sta_ph
starch113013202starch
swarth126012082swarth
aargh96314083_aargh
acaleph1453443acaleph
acari75020283acar_i
acarid95017063acarid
acarus8312193acarus
anarch11310393anarch
arch98628443__arch
ascared10399523ascared
ascarid103910713ascarid
ascaris93613323ascaris
caliph13311403_caliph
camp106336453_camp_
campi116217783_campi
campo115219763_campo
camps116330263_camps
campy145116183_campy
cap76758983_ca_p_
cape87242783_ca_pe
caphs124515373_ca_phs
capo85829213_ca_po
caps87147893_ca_ps
car59165563_car__
carat75048793_carat
carb85143163_car_b
carbo94923843_carbo
carbs96031463_carbs
card710245873_car_d
cards85137933_cards
care66968373_car_e
cared86050093_cared
carer74942333_carer
cares77369183_cares
caret75360563_caret
carex144822293_carex
cargo85322073_cargo
cark105539273_car_k
carks115534213_carks
carl65144783_car_l
carle74535703_carle
carls77037423_carls
carn66245433_car_n
carns75937563_carns
carny105822923_carny
carob95325223_carob
caroch13911763_caroch
carol75128613_carol
carom95025563_carom
carpal103716253_carpal
carped115923763_carped
carpel105418473_carpel
carper104923633_carper
carpet104530093_carpet
carpus105514303_carpus
carr65434703_car_r
carrs75730853_carrs
carry105823783_carry
cars67364763_car_s
carse74934333_carse
cart66570343_car_t
carte75940423_carte
carts78946293_carts
carve106227753_carve
cash96636283_ca_sh
catch125120373_catch
ceriph1398463_ceriph
corps95927043_corps
crap85731843_crap_
crape96128443_crape
craps95328643_craps
crash109120013_crash
curch124415413_curch
dearth104212513dearth
earth85023053_earth
ecarte84313503ecarte
eparch13258423eparch
escape103811663esca_pe
escar74011993escar__
escarped1355163escarped
escars83913133escar_s
exarch18196173exarch
garth94720223_garth
graph115315613gra_ph
harp96134283_harp_
harps105926863_harps
harpy136418203_harpy
harsh116418053_harsh
hearth125315213hearth
inarch1139163inarch
kaph135815753_ka_ph
khaph17395963kha_ph
larch105919793_larch
march125622893_march
marsh105320853_marsh
morph121712513_morph
paraph13311263_paraph
parch125123003_parch
ralph1078743_ralph
sacra74516993sacr_a
sacral83414413sacral
sacred94917103sacred
sacrum103910143sacrum
saith85826553s_aith
salp64534093s_alp_
salpa75018353s_alpa
salps74423243s_alps
samp85733593s_amp_
samps96124673s_amps
sangh95517453s_angh
sap56463233s_a_p_
sappy125413473s_appy
saps65346373s_a_ps
saran53730303s_aran
sarape84817573s_arape
sard55344243s_ar_d
sards64736183s_ards
saree55044663s_aree
sarge65531133s_arge
sargo65424413s_argo
sari45444043s_ar_i
sarin55239253s_arin
saris54544953s_aris
sark84938973s_ar_k
sarks96632463s_arks
sarky125521783s_arky
sarod65325873s_arod
saros55238063s_aros
sash77235303s_a_sh
sauch104918773s_auch
saugh95318403s_augh
scab85926713sca__b
scabby1535503scabby
scabs94818643sca_bs
scad75725763sca__d
scads85419953sca_ds
scag76626893sca__g
scags85520973sca_gs
scalar83612433scalar
scald84818123sca_ld
scalds94813693scalds
scale74629143sca_le
scaled94822443scaled
scaler84321603scaler
scales84529313scales
scall74420373sca_ll
scalls84218203scalls
scalped124411993scalped
scalpel11377713scalpel
scalper113912923scalper
scaly104718723sca_ly
scam85932353sca__m
scamped144711963scamped
scamper134613163scamper
scampish1744893scampish
scams94423973sca_ms
scan65530453sca__n
scans74625103sca_ns
scant79735073sca_nt
scants85219723scants
scanty114014663scanty
scaped115519553scaped
scapes105122263scapes
scarabs1137293scarabs
scarcer113911373scarcer
scarers94618503scarers
scarfed134711183scarfed
scarfer124511083scarfer
scarfpin1553033scarfpin
scarier94017873scarier
scarify1537443scarify
scarily12311703scarily
scaring103421973scaring
scarlet91516943scarlet
scarpers124712513scarpers
scarphing1735243scarphing
scarping133312463scarping
scarred104512633scarred
scarted104816123scarted
scarves124511623scarves
scat65848373sca__t
scathe114414993scathe
scats75930603sca_ts
scatt76030093sca_tt
scatts85914663scatts
scatty115310653scatty
scauper11379453scauper
scaur75814903sca_ur
scaurs85512043scaurs
schappe1635263schappe
schrik15206703schrik
schrod1247883schrod
scirrhi1242293scirrhi
scooch13228123scooch
scoop95617163scoop_
scoops105414363scoops
scop85925523sc_op_
scope94821483sc_ope
scops95820193sc_ops
score75526733scor_e
scored94621133scored
scorer84818253scorer
scores84725923scores
scoria8513483scoria
scorn75817443scor_n
scorns85713013scorns
scotch13207513scotch
scouth115011153scouth
scrag85916173sc_rag
scrags95713803scrags
scraich1436763scraich
scraigh1335673scraigh
scram910621613sc_ram
scrams105216623scrams
scraped124313133scraped
scraper114513403scraper
scrapes116217663scrapes
scrapie115010943scrapie
scrappy16234473scrappy
scratch1446013scratch
scrawl11208083scrawl
scree720031703sc_ree
screw109318533sc_rew
scrim95419723sc_rim
scrip96619193sc_rip
scrips105316033scrips
script105717903script
scrod85115063sc_rod
scrub94914203sc_rub
scrum95418193sc_rum
scry96017763sc_r_y
sculch13226213sculch
sculp95314843sculp_
sculps104611753sculps
sculpt104412693sculpt
scup84822383sc_up_
scups95316653sc_ups
scurf104719323scur_f
scurfs113210813scurfs
scurfy14338763scurfy
scurry11419583scurry
scurvy14386103scurvy
scutch13247083scutch
scyphi1643173sc_yphi
sear47353843sear__
seared75232843seared
searer65432023searer
sears54744913sear_s
serape84818413serape
seraphs12408093seraphs
shah105627783sha__h
shape105125113sha_pe
shard96125963shar_d
shards104319173shards
share86437083shar_e
shared105829063shared
sharer95025483sharer
shares95236413shares
sharia93116723sharia
shariah132210533shariah
sharif122917113sharif
shark126225023shar_k
sharks135019723sharks
sharn84823703shar_n
sharns95516983sharns
sharny124711833sharny
sharped134112043sharped
sharpen12389723sharpen
sharper124312703sharper
sharpie1238383sharpie
sharply15406833sharply
shaugh13287433shaugh
sherpa1138093sherpa
sirrah9379753sirrah
slap66434043sla_p_
slaps76025713sla_ps
slash84719683sla_sh
slatch114510533slatch
slurp74014983slurp_
slurps84410003slurps
smarm95517603smar_m
smarms105712533smarms
smarmy13629353smarmy
smart75834093smar_t
smarts86218003smarts
smarty115013793smarty
smash104814433sma_sh
smirch1356463smirch
snap65727033sna_p_
snappy1366103snappy
snaps74719563sna_ps
snare54429983snar_e
snared74824553snared
snarer64620843snarer
snares65329033snares
snarf86525423snar_f
snarfs95113423snarfs
snark95419943snar_k
snarks104815733snarks
snarky134210843snarky
snarl54921083snar_l
snarls64016873snarls
snarly93815003snarly
snash84815673sna_sh
snatch114310603snatch
snath86419803sna_th
soap65831133soa_p_
soaps75120713soa_ps
soapy106114783soa_py
soar46838673soar__
soared74324293soared
soarer64522243soarer
soars54732513soar_s
soph97024203s__oph
spar65433303spar__
spare75135563spar_e
spared95427483spared
sparer84524963sparer
spares84834553spares
sparge94216043sparge
sparid94016933sparid
spark114920893spar_k
sparks124616363sparks
sparky154511523sparky
sparry115111303sparry
spars75431543spar_s
sparse84516343sparse
stamp95217363stamp_
stamps105614023stamps
stanch113812373stanch
staphs114411033sta_phs
star48037763star__
starchy15286743starchy
stare54440263star_e
stared75429873stared
starer64027363starer
stares66038753stares
stark95425623star_k
starry94911673starry
stars55836573star_s
start55642313star_t
starts65423123starts
starve94613743starve
stash84916973sta_sh
stirp76815503stirp_
stirps85011813stirps
strap77925263strap_
straps87721783straps
strath93216363strath
surah86823253s_urah
svaraj1634963svaraj
swamp125015323swamp_
swamps135910263swamps
swampy16437233swampy
swap95925433swa_p_
swaps104819203swa_ps
swaraj1636023swaraj
sward94221463swar_d
swards105415133swards
sware85828213swar_e
swarf115324653swar_f
swarfs125612063swarfs
swarm106218833swar_m
swarms116112163swarms
swart86234643swar_t
swarths13537323swarths
swarthy16466373swarthy
swarty125812383swarty
swash116316753swa_sh
swatch14549283swatch
swath115920383swa_th
sylph1347793s_ylph
syncarp1444533syncarp_
syncarps1543903syncarps
syncarpy1842483syncarpy
syph125413273s__yph
tarp66936413_tarp_
tarps76527113_tarps
teraph11319093teraph
warp95635003_warp_
warps107126423_warps

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.1431249587.4
2DLD Change Limit1127164275.95018943.9
3Display Results4274270.1263388.9
 (SQL Overall)1786914276.21928733.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.