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

143 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
sended8512123(None) 
bended105521231bended
ended74421261_ended
fended114216911fended
mended104418681mended
pended103819011pended
rended84524101rended
sanded84920611sanded
scended11329871scended
seeded84520461seeded
sender73824411sender
sensed73918161sensed
tended83819481tended
vended114416351vended
wended113616151wended
amended11328312amended
ascended1246512ascended
banded105223172banded
beaded104922422beaded
bedded115114062bedded
bendee94121022bendee
bender95223302bender
blended114710712blended
bonded104719952bonded
ceded96118552ce_ded
censed94016322censed
deeded94615542deeded
denied84318632denied
denned84215632denned
dented84120512dented
denuded10167662denuded
emended11329602emended
ender64325862_ender
endued83910372_endued
fenced124412712fenced
fender103718722fender
feuded114010002feuded
fonded115717042fonded
funded114413892funded
gelded94512112gelded
gender83517932gender
handed114919982handed
headed114020472headed
heeded114215762heeded
hented104218752hented
herded114215642herded
kenned114411262kenned
landed84619242landed
leaded84221542leaded
lender73921272lender
lensed74015472lensed
melded104714712melded
mender93520792mender
mensed93916542mensed
minded103817832minded
needed84114442needed
penned94217612penned
ponded105218772ponded
redded94019542redded
reded74829112re_ded
reeded84022562reeded
render74024142render
rented74426592rented
rinded84418982rinded
sander74828532sander
saned65636272san_ed
scented102811882scented
seabed95017692seabed
sealed74328362sealed
seamed94823882seamed
seared75232842seared
seated75131052seated
seceded11319202seceded
seconded1236352seconded
seder64826752se_der
seed55549482se__ed
seedbed11246612seedbed
seeder74320772seeder
seeled73922092seeled
seemed95117612seemed
seeped94317522seeped
segued838512segued
seidel7311082seidel
seined74023062seined
seised74218122seised
seized164313652seized
selfed10310912selfed
send55237292sen__d
sendal73314992sendal
senders83022352senders
sends65528242send_s
sendup9106342sendup
sene46848052sen_e_
sennet64224142sennet
sense55526822sense_
sensei64712592sensei
senses63923942senses
sente56432872sente_
sered65737292se_red
serged84118762serged
served104616812served
sewed95325162se_wed
sexed136618542se_xed
shaded114518872shaded
shedded13419062shedded
sided74825952s_ided
singed85422292singed
sinned73818412sinned
sledded10378872sledded
slender83413592slender
sned56026052s_n_ed
snedded10377392snedded
sodded94113302sodded
sonde64622832sonde_
sonder73623522sonder
sondes74922872sondes
sounded93214462sounded
spaded103816752spaded
speeded113310422speeded
spender103713692spender
steaded92811672steaded
sueded84014632sueded
sunder74019822sunder
sundew10369692sundew
sunned74216322sunned
synced12266962synced
syndet10311962syndet
tedded93810892tedded
tender74121842tender
tensed74817832tensed
tented74221002tented
trended94011762trended
unended92811822unended
upended11267322upended
vendee105617262vendee
vender103418422vender
venged114011982venged
vented104617922vented
wedded123811832wedded
weeded113914872weeded
welded114013382welded
winded114918212winded
yenned10409382yenned

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.1401276364.3
2DLD Change Limit825511432.66031034.2
3Display Results1431430.0433325.6
 (SQL Overall)1786911432.84362853.0
 
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.