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

131 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
sheroot1041437(None) 
cheroot12413691cheroot
sheroots1137861sheroots
cheroots1348192cheroots
heriot9422342_heriot
sherbet12311382sherbet
shoot84235912sh__oot
beetroot1047253beetroot
bhoot104322103bh__oot
chariot12316213chariot
chert105232103cher__t
cheviot1546933cheviot
disroot8413563disroot
enroot6615993_enroot
ergot65422893__ergot
gherao1036753gherao_
harlot94422803_harlot
helot85332683_he_lot
hereat93527413_hereat
hereof123212373_hereof
hereon93914363_hereon
hereto9313693_hereto
heriots10312063_heriots
hermit11519443_hermit
hero74635783_her_o_
heroes94923823_heroes
heroic113516923_heroic
heroin94420593_heroin
heron85025503_her_on
herons94820543_herons
heros84930863_her_os
hoot75752103_h__oot
merlot83217603_merlot
outroot7516563outroot
overhot13411223overhot
pierrot948833pierrot
pokeroot1447703pokeroot
preriot9316413preriot
reboot84119333_reboot
redroot8312903redroot
reroof9315003_reroof
root45655923___root
roseroot859513roseroot
saleroom1047463saleroom
scherzo2153943scherzo_
scherzos2243703scherzos
scoot75729153s__coot
scroop10299783s_croop
seaboot9512333seaboot
serest64831613s_erest
sermon8413553s_ermon
serosa6313023s_erosa
serous65023563s_erous
serow86720443s_er_ow
serows96016393s_erows
servo84516683s_ervo_
servos93812723s_ervos
setout64719463s_etout
sexpot1539543s_expot
shadoof1446133shadoof
shallot103614133shallot
sheepcot15114253sheepcot
sheerest11310083sheerest
sheet84836963she__et
shent85933503she__nt
sheol84318373she__ol
sheols94614163she_ols
sherbert1348793sherbert
sherbets1335213sherbets
sherd96321153sher__d
sherds105614723sher_ds
shereef1337743shereef
sherif122915243sher_if
sheriff16287693sheriff
sherifs13299683sherifs
sherlock1744243sherlock
sherpa1138093sher_pa
sherpas1238093sherpas
sherris10168803sherris
sherry124510413sher_ry
shirt84533903shir__t
shnook1366343sh_nook
shoat85633953sh__oat
shoo75929893sh__oo_
shook124920163sh__ook
shool84523153sh__ool
shoon84022013sh__oon
shoos84226363sh__oos
shoots94619363sh__oots
short85040533sh__ort
shot76150263sh___ot
shott85332193sh__ott
shout85433173sh__out
showroom1654063showroom
shrift12413543sh_rift
shroff1538503sh_roff
shroud1038773sh_roud
shrove125412233sh_rove
shutout1048533shutout
snakeroot1364963snakeroot
snoot55030143s__noot
soot45761063s___oot
spheroid1447283spheroid
sprout8419403s_prout
stereo65317913stereo_
stereos74314973stereos
sterlet71318473sterlet
steroid81314863steroid
sterol6613333ster_ol
sterols7313443sterols
stertor7310093stertor
strook10410303s_trook
sunroof1047053sunroof
sunroom947013sunroom
superhot13410223superhot
taproot9412673taproot
thereat104315243thereat
thereof13168063thereof
thereon10199263thereon
thereto1038993thereto
thermit12312013thermit
thermos124610753thermos
theroid11313403theroid
theropod1445433theropod
throat94819753th_roat
unroot6315553_unroot
uproot8314123_uproot
whereat134311923whereat
whereof16185463whereof
whereon13196503whereon
whereto1346063whereto

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.420425454.8
2DLD Change Limit1340271316.33021173.3
3Display Results1311310.0462847.8
 (SQL Overall)1786911316.79626293.6
 
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.