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

130 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
spears8401947(None) 
pears75138611_pears
sears54744911s_ears
shears93820901shears
smears84714431smears
spars75431541sp_ars
speaks125114581speaks
speans85417141speans
spear75821061spear_
speers85019951speers
speirs85013231speirs
swears94114071swears
anears63717182anears
apers76629132ape_rs
appears11308952appears
aspers86220312aspe_rs
bears75739042_bears
blears85116452blears
clears84116562clears
dears65736882_dears
drears74614252drears
ears46356592__ears
fears84829392_fears
gears64628692_gears
hears86737372_hears
lears55938732_lears
nears55529422_nears
operas8312452operas
pars67560792_p_ars
peags86122842_peags
peaks114825622_peaks
peals75235492_peals
peans75437642_peans
pear69745232_pear_
pearl75324462_pearl
pearls84715382_pearls
peart76440752_peart
peas65755062_pea_s
peats76140192_peats
peers75130272_peers
rears54739652_rears
scars75433532s_cars
seals54839692s_eals
seams75731662s_eams
sear47353842s_ear_
seas45755272s_ea_s
seats54844342s_eats
seers55136382s_eers
sepals85217372sepals
sers45746652s_e_rs
sewars94018622sewars
sheafs124912882sheafs
sheals94420642sheals
shear85424832shear_
sheas86331792shea_s
sheers94322402sheers
shmears1277072shmears
sieurs659042sieurs
simars84916932simars
sitars65417592sitars
sizars154812622sizars
skeans104512912skeans
smear74416392smear_
smeary114110802smeary
sneaks104312492sneaks
sneaps84510862sneaps
sneers64016172sneers
soars54732512s_oars
sofars94712782sofars
sonars64818972sonars
sowars94318002sowars
spaes76029972sp_aes
spams94922192sp_ams
spans74528732sp_ans
spar65433302sp_ar_
spare75135562sp_are
spares84834552sp_ares
spark114920892sp_ark
sparks124616362sp_arks
sparse84516342sp_arse
spas67036722sp_a_s
spats75031382sp_ats
spays105520512sp_ays
speak114618672spea_k
speakers14299452speakers
spean74620512spea_n
speared104314422speared
spearer93913662spearer
spearers103711142spearers
specks144312702specks
specs96916672spe_cs
speeds94316052speeds
speels85116392speels
speer74623902speer_
speils84116222speils
speir75315362speir_
speiss84311642speiss
spells84617682spells
spelts84614642spelts
spends94714472spends
sperm93216012spe_rm
sperms102512602sperms
spewers124210652spewers
spews105015922spe_ws
spiers84421742spiers
splats84817302splats
splays114910872splays
spoors84014022spoors
sprags95715822sprags
sprats85819932sprats
sprays115913642sprays
spreads1039762spreads
spurs74621522sp_urs
stars55836572s_tars
steads74116222steads
steaks104415852steaks
steals64020062steals
steams84916902steams
steers63820982steers
suers55128482sue_rs
sugars7312422sugars
supers84622402supe_rs
swear85316852swear_
sweats94814612sweats
tears55436462_tears
upbears1195422upbears
uprears9107492uprears
uptears9106442uptears
wears86030302_wears
years84527672_years

Search took 6 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 Filter178691825510.1261418182.5
2DLD Change Limit825511304.92016778.7
3Display Results1301300.1261031.7
 (SQL Overall)1786911305.17234549.7
 
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.