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

313 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
scarphs1443741(None) 
scarph13429601scarph_
scarps104718601scarp_s
caphs124515372_ca_phs
carps96932252_carp_s
carpus105514302_carpus
escarps11397372escarp_s
scalps104315232scalp_s
scamps125014172scamp_s
scapes105122262sca_pes
scarabs1137292scarabs
scarers94618502scarers
scares85033002scar_es
scarfs114714682scar_fs
scarp95724102scarp__
scarped124314392scarped
scarper114814822scarper
scarpers124712512scarpers
scarphed1635432scarphed
scars75433532scar__s
scarts85321492scar_ts
scarves124511622scarves
scaups105411932scaup_s
scrapes116217662scrapes
scraps106017242scrap_s
seraphs12408092seraphs
sharps115516082sharp_s
staphs114411032sta_phs
swarths13537322swarths
acalephs1542993acalephs
acarids105312243acarids
acarpous1245313acarpous
acarus8312193acar_us
anarchs1237093anarchs
ascarids11438503ascarids
ascaris93613323ascar_is
caliphs1436753_caliphs
campos125217953_campos
camps116330263_camp_s
campus125213923_campus
capes95441923_ca_pes
caph116623293_ca_ph_
capos94826073_ca_pos
capris10415073_capris
caps87147893_ca_p_s
carats85929023_carats
carbos105122263_carbos
carbs96031463_car_bs
cards85137933_car_ds
carers85133953_carers
cares77369183_car_es
caress85720263_caress
carets85330773_carets
cargos94619183_cargos
caries85147623_caries
carks115534213_car_ks
carles85435083_carles
carls77037423_car_ls
carns75937563_car_ns
carobs104818103_carobs
carols85124983_carols
caroms105619573_caroms
carp85139813_carp__
carpal103716253_carpal
carpals113414623_carpals
carped115923763_carped
carpel105418473_carpel
carpels115315463_carpels
carper104923633_carper
carpers114521253_carpers
carpet104530093_carpet
carpets113915333_carpets
carpi94319393_carp_i
carrs75730853_car_rs
cars67364763_car__s
carses85233653_carses
cartes86239473_cartes
carts78946293_car_ts
carves115128453_carves
ceriphs1484753_ceriphs
corps95927043_corp_s
corpus106015293_corpus
crapes104727693_crapes
craps95328643_crap_s
dearths11498843dearths
earths95014593_earths
ecartes94212563ecartes
eparchs14196243eparchs
escapes113811673esca_pes
escarp10449003escarp__
escarped1355163escarped
escars83913133escar__s
exarchs19165193exarchs
garths104111503_garths
graphs124510153gra_phs
harps105926863_harp_s
hearths135311073hearths
kaphs144911503_ka_phs
khaphs18394323kha_phs
morphs13149433_morphs
paraphs1439313_paraphs
ralphs1135373_ralphs
sacrals93311793sacrals
sacrums11388043sacrums
salpas85116923s_alpas
salps74423243s_alp_s
samps96124673s_amp_s
sanghs105312063s_anghs
saps65346373s_a_p_s
sarans64224433s_arans
sarapes94617743s_arapes
sards64736183s_ar_ds
sarees65329943s_arees
sarges75128593s_arges
sargos74318273s_argos
sarins63932623s_arins
saris54544953s_ar_is
sarks96632463s_ar_ks
sarods74918573s_arods
saros55238063s_ar_os
sauchs115112233s_auchs
saughs104812053s_aughs
scabies11613333scabies
scabrous1245993scabrous
scabs94818643sca__bs
scads85419953sca__ds
scags85520973sca__gs
scalars93711903scalars
scalds94813693sca_lds
scalers93817263scalers
scales84529313sca_les
scalls84218203sca_lls
scalp95217983scalp__
scalped124411993scalped
scalpel11377713scalpel
scalpels12345883scalpels
scalper113912923scalper
scalpers123710863scalpers
scamp115717313scamp__
scamped144711963scamped
scamper134613163scamper
scampers143611033scampers
scampi12469103scamp_i
scampies1439323scampies
scampish1744893scampish
scams94423973sca__ms
scans74625103sca__ns
scants85219723sca_nts
scape96921843sca_p_e
scaped115519553sca_ped
scapose1147753sca_pose
scar66434203scar___
scarab10310063scar_ab
scarce104013633scar_ce
scarcer113911373scarcer
scarcest12169173scarcest
scare75334463scar__e
scared95227293scar_ed
scarer84524603scar_er
scarey115016983scar_ey
scarf105427143scar__f
scarfed134711183scarfed
scarfer124511083scarfer
scarfers13408463scarfers
scarfpin1553033scarfpin
scarfpins1653043scarfpins
scarier94017873scarier
scariest101615943scariest
scarify1537443scarify
scarily12311703scarily
scaring103421973scaring
scariose1037593scariose
scarious10610203scarious
scarless10189053scarless
scarlet91516943scarlet
scarlets10178573scarlets
scarphing1735243scarphing
scarping133312463scarping
scarred104512633scarred
scarry116311183scar_ry
scart76139773scar__t
scarted104816123scarted
scary105222593scar__y
scathe114414993sca_the
scathes124515713scathes
scats75930603sca__ts
scatts85914663sca_tts
scaup95515993scaup__
scauper11379453scauper
scaupers12378173scaupers
scaurs85512043sca_urs
schappes1736033schappes
schriks16185743schriks
schrods1337433schrods
scirrhi1242293scirrhi
scirrhus1342003scirrhus
scoops105414363scoop_s
scopes104719593sc_opes
scops95820193sc_op_s
scorch13198093scorch_
scorches15189143scorches
scorers94115313scorers
scores84725923scor_es
scorns85713013scor_ns
scouths12527893scouths
scrags95713803sc_rags
scraichs1543993scraichs
scraighs1443633scraighs
scrams105216623sc_rams
scrap97120403scrap__
scrape105917573scrap_e
scraped124313133scraped
scraper114513403scraper
scrapers125510513scrapers
scrapie115010943scrapie
scrapies124612473scrapies
scrappy16234473scrappy
scrawls12177273scrawls
screes85023963sc_rees
screws115513883sc_rews
scries85226823sc_ries
scrims104615933sc_rims
scrips105316033sc_rips
scripts11509373scripts
scrods94111603sc_rods
scrubs104210313sc_rubs
scrums104614253sc_rums
sculps104611753sculp_s
sculpts11377063sculpts
scups95316653sc_up_s
scurfs113210813scur_fs
scyphi1643173sc_yphi
scyphus1743203sc_yphus
search113312423search_
searches132112903searches
sears54744913sear__s
serapes95218103serapes
seraph114011163seraph_
shahs115919513sha__hs
shapes115124943sha_pes
shards104319173shar_ds
sharers104720623sharers
shares95236413shar_es
shariahs14206393shariahs
sharias102516003sharias
sharifs13279903sharifs
sharks135019723shar_ks
sharns95516983shar_ns
sharp104922533sharp__
sharped134112043sharped
sharpen12389723sharpen
sharpens13377813sharpens
sharper124312703sharper
sharpers133810943sharpers
sharpest1339143sharpest
sharpie1238383sharpie
sharpies13411223sharpies
sharply15406833sharply
sharpy145211033sharp_y
shaughs14245283shaughs
sherpas1238093sherpas
sirrahs10377303sirrahs
slaps76025713sla_p_s
slurps84410003slurp_s
smarms105712533smar_ms
smarts86218003smar_ts
snaps74719563sna_p_s
snarers74216663snarers
snares65329033snar_es
snarfs95113423snar_fs
snarks104815733snar_ks
snarls64016873snar_ls
snaths95112913sna_ths
soaps75120713soa_p_s
soarers74118093soarers
soars54732513soar__s
sophs104916023s__ophs
sparers94519613sparers
spares84834553spar_es
sparges104016333sparges
sparids103512123sparids
sparks124616363spar_ks
spars75431543spar__s
stamps105614023stamp_s
stapes85028733sta_pes
staph104314653sta_ph_
starch113013203starch_
starches131912913starches
starchy15286743starchy
starers74522313starers
stares66038753star_es
starets73515923starets
stars55836573star__s
starts65423123star_ts
starves104614553starves
stirpes95011293stirpes
stirps85011813stirp_s
straps87721783strap_s
straths102711713straths
surahs94515543s_urahs
swamps135910263swamp_s
swaps104819203swa_p_s
swards105415133swar_ds
swarfs125612063swar_fs
swarms116112163swar_ms
swarth126012083swarth_
swarthy16466373swarthy
swaths125312643swa_ths
sylphs1435543s_ylphs
syncarps1543903syncarp_s
syphs13519453s__yphs
tarps76527113_tarp_s
warps107126423_warp_s

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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273136.08022043.9
3Display Results3133130.1102845.5
 (SQL Overall)1786913136.34628158.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.