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

117 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
speans8541714(None) 
peans75437641_peans
skeans104512911skeans
spans74528731sp_ans
speaks125114581speaks
spean74620511spean_
spears84019471spears
aspens85013352aspe_ns
beans75734692_beans
cleans85817052cleans
deans66131392_deans
gleans75014742gleans
jeans126022112_jeans
leans55536252_leans
means75831232_means
oceans81211002oceans
opens76118552ope_ns
paeans85118262paeans
pans65855732_p_ans
peags86122842_peags
peaks114825622_peaks
peals75235492_peals
pean66147172_pean_
pears75138612_pears
peas65755062_pea_s
peats76140192_peats
pecans101515832_pecans
peens76428192_peens
peins76128062_peins
pekans121710552_pekans
pens65649642_pe_ns
peons75327182_peons
pians75126962_pians
plans75731272_plans
queans153110752queans
sans45153362s__ans
sarans64224432sarans
scans74625102s_cans
scenas84114702scenas
seals54839702s_eals
seams75731662s_eams
sears54744912s_ears
seas45755272s_ea_s
seats54844342s_eats
sedans74816092sedans
sepals85217382sepals
sewans95215902sewans
sheafs124912882sheafs
sheals94420642sheals
shears93820902shears
sheas86331792shea_s
sheens95116992sheens
skean94415622skean_
skeane104611372skeane
skeanes113610712skeanes
skeens103912912skeens
skeins103911902skeins
smears84714432smears
sneaks104312492sneaks
sneaps84510862sneaps
solans64122492solans
somans84619302somans
sowans94215892sowans
spaes76029972sp_aes
spams94922192sp_ams
span65234662sp_an_
spang84919732sp_ang
spank115919572sp_ank
spanks124514122sp_anks
spars75431542sp_ars
spas67036722sp_a_s
spats75031382sp_ats
spawns11577922spawns
spays105520512sp_ays
speak114618672spea_k
speaned103411522speaned
spear75821062spea_r
specks144312702specks
specs96916672spe_cs
speeds94316052speeds
speels85116392speels
speers85019952speers
speils84116222speils
speirs85013232speirs
speiss84311642speiss
spells84617682spells
spelts84614642spelts
spend85619332spe_nd
spends94714472spends
spense83912432spe_nse
spent75532832spe_nt
sperms102512602sperms
spews105015922spe_ws
spins75327982sp_ins
splats84817302splats
splays114910872splays
spleens937102spleens
spoons84116022spoons
sprags95715822sprags
sprains93013592sprains
sprang95713522sprang
sprangs104610052sprangs
sprats85819932sprats
sprays115913642sprays
spreads1039762spreads
spurns84811382spurns
steads74116222steads
steaks104415852steaks
steals64020062steals
steams84916902steams
steins64818342steins
sterns64616762sterns
swans84625012s_wans
swears94114072swears
sweats94814612sweats
weans85326742_weans
yeans86624882_yeans

Search took 3 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.360496363.9
2DLD Change Limit825511172.36034979.2
3Display Results1171170.0303900.0
 (SQL Overall)1786911172.75064978.5
 
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.