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

170 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
seined7402306(None) 
peined94918841peined
reined74425521reined
sained75424241sained
seine55732871seine_
seiner64622481seiner
seines65029901seines
seised74218121seised
seized164313651seized
shined104620781shined
skeined1236771skeined
spined95423941spined
veined104413911veined
alined75221402alined
beaned95621472beaned
brined95118412brined
ceiled94114952ceiled
chined125620062chined
coined94523602coined
deaned84620452deaned
defined123813822defined
deiced104214482deiced
deigned1037502deigned
denied84318632denied
denned84215632denned
dined76431992_dined
dwined114610212dwined
feigned1245352feigned
feinted11379622feinted
fined94930502_fined
foined105915012foined
gained84617462gained
heiled104415612heiled
heired103813042heired
jeaned143813462jeaned
joined144613072joined
keened114013632keened
kenned114411272kenned
kerned114112932kerned
leaned73422542leaned
lined64934642_lined
mined85333352_mined
neoned7311492neoned
opined95113852opined
pained95622852pained
peened94318162peened
peised94817682peised
penned94217612penned
pined85935322_pined
rained75024602rained
refined114720002refined
reigned949212reigned
reinked1239792reinked
reived104518132reived
relined85321932relined
repined104918772repined
resined84522652resined
ruined74813322ruined
sailed74327762sailed
sainted84114242sainted
saned65636272s_aned
seabed95017692seabed
sealed74328362sealed
seamed94823882seamed
seared75232842seared
seated75131062seated
seed55549482se__ed
seeded84520462seeded
seeled73922092seeled
seemed95117612seemed
seeped94317522seeped
segued838512segued
seidel7311082seidel
seiners74219272seiners
seise54727852seise_
seiser65318342seiser
seises64026712seises
seize143819502seize_
seizer154114572seizer
seizes154317532seizes
selfed10310912selfed
send55237292se_n_d
sended85121232sended
sene46848052se_ne_
sennet64224142sennet
sensed73918162sensed
sequined18105652sequined
sered65737292se_red
serged84118772serged
serifed11811462serifed
serine65432672serine_
serines74229542serines
served104616812served
sewed95325162se_wed
sexed136618542se_xed
sheened113511702sheened
shied96125492shi_ed
shine85533092shine_
shiner93820872shiner
shines95028912shines
shinned114310922shinned
shrined114112412shrined
sided74825952s_ided
sieged85212712sieged
sieved104611442sieved
signed83413752signed
sine46560622s_ine_
sines55954822s_ines
sinew84718922s_inew
singed85422292s_inged
sinned73818412sinned
siped84927682s_iped
sired66134282s_ired
sited65130742s_ited
sized155519242s_ized
skied104417752ski_ed
skinked11339012skinked
skinned12387292skinned
skited114313482skited
skived14429892skived
sliced94416312sliced
slimed94915122slimed
slinked123011382slinked
sliped95417062sliped
smiled93716432smiled
sned56026052s__ned
sniped94913482sniped
soiled73822472soiled
sorned74820042sorned
speaned103411522speaned
speiled104412122speiled
speired103811102speired
spiced115218312spiced
spied85427712spi_ed
spiked134915552spiked
spiled94621992spiled
spine76534422spine_
spinel85317332spinel
spines85132032spines
spinet85629752spinet
spired94921862spired
spited94820442spited
splined105013112splined
stained84215342stained
staned74824642staned
stied65723032sti_ed
stinted82914192stinted
stiped94517072stiped
stoned75923142stoned
suited74019422suited
sunned74216322sunned
swine85625302swine_
swinged123810792swinged
swinked15349032swinked
swiped123811092swiped
swived133610632swived
teind6213612tein_d
tined65434532_tined
trined74920712trined
twined104413122twined
veiled103714542veiled
veiner94514752veiner
vined95626152_vined
weaned103816152weaned
weened104013732weened
weiner94214132weiner
whined134715202whined
wined94434182_wined
yeaned103813902yeaned
yenned10409382yenned

Search took 8 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.830215290.4
2DLD Change Limit825511706.51312674.8
3Display Results1701700.0632698.4
 (SQL Overall)1786911707.40624127.9
 
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.