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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

116 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
glandered123634(None) 
gandered112211171g_andered
slandered1137471slandered
blundered1335192blundered
dandered112110962_dandered
gendered11258872g_endered
glaciered1343882glaciered
gladdened1342582gladdened
glanders103811502glander_s
laddered1136742_laddered
laundered1185022_laundered
meandered1346142meandered
pandered121812572_pandered
plundered1344312plundered
slanderer1046672slanderer
wandered132110792_wandered
angered93013473__angered
bannered11299323_bannered
bantered113313633_bantered
blabbered13184593blabbered
blander103715163blander__
blanketed1643913blanketed
blathered15168363blathered
blattered12198573blattered
blazered2035063bla_zered
blinkered1644413blinkered
blunderer1244543blunderer
calendered1443393calendered
cancered132411553_cancered
cankered153010223_cankered
cantered113415983_cantered
cindered1239793_cindered
clabbered16184763clabbered
clambered16146133clambered
clangored1343663clangored
clattered12178413clattered
clavered14187633cla_vered
clinkered1634773clinkered
cylindered1742063cylindered
dangered11248513_dangered
daundered1294423daundered
fendered13258673_fendered
flanneled1343313flanneled
flattered13188633flattered
floundered1542423floundered
foundered1435403foundered
gander84322763g_ander__
ganders93521703g_ander_s
gardened1137003g_ardened
garnered10247113g_arnered
gartered10319593g_artered
gathered13149383g_athered
gingered11127743g_ingered
glaceed1136203gla_ce_ed
gladded11357453gla_d_ded
gladdener1252403gladdener
gladder10398313gladder__
glaired9387753gla__ired
glamoured1343203glamoured
glanced11439233glan__ced
glancer103710073glancer__
glancers11408003glancer_s
glandes95413833gland__es
glandule1043853glandule_
glandules1144253glandules
glared84715203gla___red
glimmered1543103glimmered
glistered11176303glistered
glittered11195413glittered
glowered1345753gl_owered
grandee93115513grande_e_
grandees103211283grande_es
grander93315873grander__
hankered16289443_hankered
hindered1339453_hindered
laagered1055853_laagered
lackered15108683_lackered
ladened979053_la_dened
lagered92311153_la_gered
lanceted1137073_lanceted
landed84619243_land__ed
lander74028483_lander__
landers84026213_lander_s
lanneret82512363_lanneret
lappered13288213_lappered
lathered121512333_lathered
launderer1094513_launderer
laveered1235253_laveered
lavendered1541943_lavendered
lawyered1534033_lawyered
layered11259413_la_yered
lingered10129643_lingered
mannered11249653_mannered
maundered1394943maundered
meanderer1244733meanderer
panderer112210913_panderer
philandered1852243philandered
plastered1288903plastered
plunderer1243753plunderer
pondered126411293_pondered
relaundered1352043relaundered
rendered102512263_rendered
slabbered14165083slabbered
slander84015443slander__
slanderers1145143slanderers
slanders94014013slander_s
slathered13148553slathered
slavered12188033sla_vered
slenderer1044893slenderer
squandered2142713squandered
sundered10312153_sundered
tendered102510603_tendered
thundered1444573thundered
unlaundered1351943unlaundered
wanderer122210123_wanderer
wondered13239943_wondered

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411167.50019818.8
3Display Results1161160.0462521.7
 (SQL Overall)1786911167.96622431.7
 
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.