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

125 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
mended10441868(None) 
amended11328301amended
bended105521231bended
emended11329601emended
ended74421261_ended
fended114216911fended
melded104714711melded
mender93520791mender
mensed93916541mensed
minded103817831minded
pended103819011pended
rended84524101rended
sended85121231sended
tended83819481tended
vended114416351vended
wended113616151wended
amender10349612amender
banded105223172banded
beaded104922422beaded
bedded115114062bedded
bendee94121022bendee
bender95223302bender
blended114710712blended
bonded104719952bonded
ceded96118552ce_ded
censed94016322censed
deeded94615542deeded
denied84318632denied
denned84215632denned
dented84120512dented
denuded10167662denuded
emender10649842emender
ender64325862_ender
endued83910372_endued
fenced124412712fenced
fender103718722fender
feuded114010002feuded
fonded115717042fonded
funded114413892funded
gelded94512112gelded
gender83517932gender
handed114919982handed
headed114020472headed
heeded114215762heeded
hented104218752hented
herded114215642herded
impended1435952impended
kenned114411262kenned
landed84619242landed
leaded84221542leaded
lender73921272lender
lensed74015472lensed
madded113513552madded
maned86634092man_ed
manned94418642manned
meander1049972meander
meated94222402meated
meddled123210022meddled
meed74934702me__ed
melder93915812melder
melled95023022melled
melted94219062melted
menaced122710092menaced
menad85918982men_ad
mend75334022men__d
menders103818802menders
mends84927692mend_s
mense75025632mense_
menses84222452menses
mentee84121292mentee
meoued9118532meoued
meowed12148002meowed
merde84320122merde_
merdes94518602merdes
merged104214942merged
meshed124415932meshed
messed95018182messed
meted85424432me_ted
metred95315142metred
mewed115218012me_wed
mewled123710052mewled
milded104416152milded
minced114114912minced
minder94822502minder
mined85333352min_ed
minted94220582minted
molded104414082molded
monde85723142monde_
mondes94322352mondes
monied94319462monied
mounded113711982mounded
mudded114511382mudded
needed84114442needed
omened93711002omen_ed
penned94217612penned
ponded105218772ponded
redded94019542redded
reded74829112re_ded
reeded84022562reeded
remended123010392remended
render74024142render
rented74426592rented
rinded84418982rinded
sanded84920612sanded
scended11329872scended
seeded84520462seeded
sender73824412sender
sensed73918162sensed
tedded93810892tedded
tender74121842tender
tensed74817832tensed
tented74221002tented
trended94011762trended
unended92811822unended
unmended12299092unmended
upended11267322upended
vendee105617262vendee
vender103418422vender
venged114011982venged
vented104617922vented
wedded123811832wedded
weeded113914872weeded
welded114013382welded
winded114918212winded
yenned10409382yenned

Search took 5 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.1101624463.6
2DLD Change Limit825511254.65617730.0
3Display Results1251250.0761644.7
 (SQL Overall)1786911254.84236904.4
 
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.