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

140 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
spear7582106(None) 
pear69745231_pear
sear47353841s_ear
shear85424831shear
smear74416391smear
spar65433301sp_ar
speak114618671speak
spean74620511spean
spears84019471spears
speer74623901speer
speir75315361speir
swear85316851swear
anear55420322anear
apeak115513452apeak
aper66336232ape_r
appear10379342appear
asper75520432aspe_r
bear66844642_bear
blear75918682blear
clear76219052clear
dear55343602_dear
drear65016902drear
ear36867882__ear
fear75337792_fear
gear55934972_gear
hear76143882_hear
lear47045952_lear
near45236502_near
opera7313572opera
par57467022_p_ar
pea56657242_pea_
peag75431342_peag
peak106535202_peak
peal68648102_peal
pean66147172_pean
pearl75324462_pearl
pears75138612_pears
peart76440752_peart
peas65755062_peas
peat65967932_peat
peer66238352_peer
per56353092_pe_r
rear45644552_rear
scar66434202s_car
sea36161292s_ea_
seal45654372s_eal
seam66645972s_eam
sears54744912s_ears
seas45755272s_eas
seat47575562s_eat
seer45547042s_eer
sepal77723002sepal
ser36752402s_e_r
sera46141392s_era
sewar85421102sewar
shea76031572shea_
sheaf115424122sheaf
sheal84927702sheal
shears93820902shears
sheas86331792sheas
sheer84726892sheer
shmear1176932shmear
sieur5911892sieur
simar74920812simar
sitar54820542sitar
sizar145214992sizar
skean94415622skean
smears84714432smears
smeary114110802smeary
sneak96016172sneak
sneap75514822sneap
sneer54919952sneer
soar46838672s_oar
sofar86115492sofar
solar55927342solar
sonar56523422sonar
sowar85821342sowar
spa55730812sp_a_
spae65034322sp_ae
spaed85522272spaed
spaes76029972spaes
spam85930042sp_am
span65234662sp_an
spare75135562sp_are
spark114920892sp_ark
spars75431542sp_ars
spas67036722sp_as
spat66548522sp_at
spay96631662sp_ay
spaz155626162sp_az
speaker133311212speaker
speaks125114582speaks
speans85417142speans
speared104314422speared
spearer93913662spearer
spec85821972spe_c
speck135115652speck
specs96916672specs
sped76031492spe_d
speed85526622speed
speel74420762speel
speers85019952speers
speil75618642speil
speirs85013232speirs
spell75020302spell
spelt75430192spelt
spend85619332spend
spent75532832spent
sperm93216022sperm
spew95421872spe_w
spewer115112152spewer
spews105015922spews
spier75728032spier
splat76129342splat
splay105816042splay
spoor75016352spoor
sprag86418692sprag
sprat76635972sprat
spray106720062spray
spread9312532spread
spur65321192sp_ur
star48037762s_tar
stead65520272stead
steak95219802steak
steal56125472steal
steam76322932steam
steer55423862steer
stelar64013862stelar
suer45334032sue_r
sugar6312912sugar
super74924482supe_r
swears94114072swears
sweat85628402sweat
sweer84918572sweer
tear45242882_tear
upbear1096492upbear
uprear8168792uprear
uptear896782uptear
wear75836722_wear
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.296603685.8
2DLD Change Limit538001401.40638264.6
3Display Results1401400.0463043.5
 (SQL Overall)1786911401.748102226.0
 
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.