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 “shear” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

150 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
shear8542483(None) 
hear76143881_hear
sear47353841s_ear
shea76031571shea_
sheaf115424121sheaf
sheal84927701sheal
shears93820901shears
sheas86331791sheas
sheer84726891sheer
shmear1176931shmear
smear74416391smear
spear75821061spear
swear85316851swear
ahead96817052ahead
anear55420322anear
ashlar9338192ashlar
bear66844642_bear
blear75918682blear
char95132152ch_ar
cheap126915942cheap
cheat105732452cheat
cheer105420382cheer
clear76219052clear
dear55343602_dear
drear65016902drear
ear36867882__ear
fear75337792_fear
gear55934972_gear
haar77323492_haar
head87137172_head
heal75645692_heal
heap96432892_heap
heard95222752_heard
hears86737372_hears
heart85440742_heart
heat77061422_heat
heir77523802_heir
her66547812_he_r
hoar76729162_hoar
lear47045952_lear
mishear1238392mishear
near45236502_near
pear69745232_pear
rear45644552_rear
rehear93713222rehear
rhea75017432rhea_
rheas84816952rheas
scar66434202s_car
schmear1484042schmear
sea36161292s_ea_
seal45654372s_eal
seam66645972s_eam
sears54744912s_ears
seas45755272s_eas
seat47575562s_eat
seer45547042s_eer
ser36752402s_e_r
sera46141392s_era
sewar85421102sewar
sha69837782sh_a_
shad86230912sh_ad
shag86430562sh_ag
shah105627782sh_ah
sham96436362sh_am
shard96125962sh_ard
share86437082sh_are
shark126225022sh_ark
sharn84823702sh_arn
sharp104922532sh_arp
shat76456602sh_at
shaw108132552sh_aw
shay107133342sh_ay
she66837692she__
sheafs124912882sheafs
sheals94420642sheals
sheared114516012sheared
shearer104414692shearer
sheath12412892sheath
sheave124514002sheave
shed86536152she_d
sheds96122702sheds
sheen85023312sheen
sheep105321522sheep
sheers94322402sheers
sheet84836962sheet
sheik122514662sheik
shelf115221112shelf
shell84424122shell
shend94719972shend
shent85933502shent
sheol84318372sheol
sherd96321152sherd
sherry124510412sherry
shes75734352she_s
shew108030762she_w
shewer124515112shewer
shewn115715702shewn
shews115924712shews
shier85428942shier
shikar1336802shikar
shirr84716922shirr
shmears1277072shmears
shoal83920272shoal
shoat85633952shoat
shoer84722162shoer
shofar1236312shofar
shwa106014962shwa_
shwas116415102shwas
shyer114714782shyer
sieur5911892sieur
simar74920812simar
sitar54820542sitar
sizar145214992sizar
skean94415622skean
smears84714432smears
smeary114110802smeary
sneak96016172sneak
sneap75514822sneap
sneer54919952sneer
soar46838672s_oar
sofar86115492sofar
solar55927342solar
sonar56523422sonar
sowar85821342sowar
spar65433302s_par
speak114618672speak
spean74620512spean
spears84019472spears
speer74623902speer
speir75315362speir
star48037762s_tar
stead65520272stead
steak95219802steak
steal56125472steal
steam76322932steam
steer55423862steer
stelar64013862stelar
suer45334032sue_r
sugar6312912sugar
swears94114072swears
sweat85628402sweat
sweer84918572sweer
tear45242882_tear
their85512152their
thenar92610002thenar
usher84517762ushe_r
wear75836722_wear
wheal115716182wheal
wheat114924572wheat
year76534252_year

Search took 2 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 Filter178691538000.310576422.6
2DLD Change Limit538001501.61033416.1
3Display Results1501500.0463260.9
 (SQL Overall)1786911501.96690890.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.