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 “neoned” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

61 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
neoned731148(None) 
atoned75417542atoned
beaned95621472beaned
boned85133242_boned
cloned94518802cloned
coned86040052_coned
deaned84620452deaned
deboned113411632deboned
denned84215632denned
deponed113712872deponed
droned84616862droned
honed95332262_honed
intoned8811992intoned
ironed74916012ironed
jeaned143813462jeaned
keened114013632keened
kenned114411272kenned
kerned114112932kerned
leaned73422542leaned
leone55018822leone_
leones64417722leones
meoued9118532meoued
meowed12148002meowed
mooned94216642mooned
neared75119802neared
necked134715062necked
need54934152ne__ed
needed84114442needed
nene45932062ne_ne_
nenes55329672ne_nes
neon47026422neon__
neons55818682neon_s
nerved104111682nerved
nested74720062nested
netted74118712netted
none45743172n_one_
nones55639132n_ones
nonet54540842n_onet
noosed75018012noosed
nosed65524552n_osed
noted65123842n_oted
peened94318162peened
peined94918842peined
penned94217612penned
peones83821042peones
phoned124014552phoned
reined74425522reined
rezoned173611162rezoned
seined74023062seined
stoned75923142stoned
tenoned839362tenoned
toned65435342_toned
unboned103014222unboned
unzoned172310652unzoned
veined104413912veined
weaned103816152weaned
weened104013732weened
yeaned103813902yeaned
yenned10409382yenned
zoned154020262_zoned
zooned164011082zooned

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.343520965.0
2DLD Change Limit82551612.45333653.1
3Display Results61610.0163812.5
 (SQL Overall)178691612.81263545.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.