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

143 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
sherbets133521(None) 
sherberts1443591sherberts
sherbet12311381sherbet_
overbets132510682overbets
sheets93918502she__ets
sherbert1348792sherbert
shereefs1433862shereefs
sheroots1137862sheroots
sorbets93012512s_orbets
sterlets8169272sterlets
acerbest1245463acerbest
barbets114915843_barbets
berets85822523_ber_ets
cermets1139713_cermets
chebecs1635013che_becs
cheroots1348193cheroots
cherts115617233cher__ts
chevrets16255323chevrets
ebbets10376833__ebbets
ferrets103111393_ferrets
hebes105521673_he_be_s
helmets12309073_helmets
henbits12177003_henbits
herbals122710613_herbals
herbed123513453_herbe_d
herbiest1339993_herbiest
herbless1336663_herbless
herbs105520503_herb__s
herders113914123_herders
heres86245903_her_e_s
hereto9313693_her_eto
heriots10312063_heriots
hermits12312143_hermits
heroes94923833_heroe_s
herpes115517323_herpe_s
hornets104113553_hornets
overbeats14279823overbeats
overbet122716063overbet_
overlets112312363overlets
oversets113114173oversets
overwets14219953overwets
scarlets10178573scarlets
seabeds10417223s_eabeds
secrets9311773s_ecrets
seedbeds12233703seedbeds
seeress7311573seer_ess
sennets73712583s_ennets
septets998953s_eptets
seres55448893s_er_e_s
serest64831613s_er_est
sergers83815633s_ergers
serges74225973s_erge_s
series64540973s_erie_s
serpents102410373s_erpents
servers103214833s_ervers
serves94423653s_erve_s
sestets7911473s_estets
sextets1497143s_extets
sharers104720623shar_ers
shares95236413shar_e_s
sharkers154011053sharkers
sharpens13377813sharpens
sharpers133810943sharpers
sharpest1339153sharpest
shearers113911323shearers
shearlegs1342493shearlegs
sheaves134412973sheave_s
shebean1235763she_bean
shebeans1344703she_beans
shebeen1234553she_been
shebeens1343333shebeens
shedders13267433shedders
sheeneys14294903sheeneys
sheens95116993she__ens
sheerest11310083sheerest
sheerlegs1343293sheerlegs
sheerness1236273sheerness
sheers94322403she__ers
sheet84836963she__et_
sheeters113111863sheeters
sheeves133911953sheeve_s
shegetz2044273she_getz
shekels1436043she_kels
shellers112812583shellers
shelters113412813shelters
shelvers14388813shelvers
shelves134112093shelve_s
sheqels1934753she_qels
sherds105614723sher__ds
shereef1337743sher_eef
sheriffs17253923sheriffs
sherifs13299683sher_ifs
sheroot10414373sheroot_
sherpas1238093sher_pas
sherries111812903sherries
sherris10168803sher_ris
shewers134312053she_wers
shires95225573shir_e_s
shirkers15319583shirkers
shirts94918343shir__ts
shores94830413shor_e_s
shortens11288993shortens
shortest11310783shortest
shorts95321743shor__ts
shreds105613053sh_r_eds
shrews129313923sh_r_ews
shrieks14377673sh_rieks
shrifts1335963sh_rifts
skeets104513253ske__ets
skirrets12244013skirrets
sleets64318873sle__ets
solerets839693soler_ets
somersets1144253somersets
sorbents10279133s_orbents
sorbet83924083s_orbet_
spheres123114353spher_e_s
spheriest1438383spheriest
starets73515923star_ets
starlets81610083starlets
stereos74314973ster_eos
steres63929533ster_e_s
sterlet71318473sterlet_
sternest8314433sternest
streets73312623s_treets
superbest1349963superbest
superjets1848013superjets
sweets94214433swe__ets
swervers1455213swervers
swerves1377533swerve_s
tercets93512443_tercets
terrets72913583_terrets
thebes115914493the_be_s
theres96525473ther_e_s
thereto1038993ther_eto
thermels13607763thermels
thermes126214613therme_s
thermits1338513thermits
versets103913103_versets
vervets13419753_vervets
whereas13448903wher_eas
wheres125917443wher_e_s
whereto1346063wher_eto
wherves16548063wherve_s

Search took 8 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 Filter1786911461620.420425454.8
2DLD Change Limit1461621437.42319690.4
3Display Results1431430.0632269.8
 (SQL Overall)1786911437.90622601.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.