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

75 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
glanders10381150(None) 
ganders93521701g_anders
glancers11408001glancers
glandes95413831glande_s
landers84026211_landers
slanders94014011slanders
banders104324562_banders
bilanders1235962bilanders
bladders12397802bladders
bladers104214682bla_ders
blander103715162blander_
blenders115210992blenders
blinders113911142blinders
blunders113911342blunders
branders114313092branders
clangers114312342clangers
colanders1238012colanders
danders93921182_danders
flangers123311372flangers
flankers15349302flankers
flinders12439262flinders
gadders103611502g_adders
gander84322762g_ander_
gangers94418602g_angers
genders93616782g_enders
glaciers11277892glaciers
gladdens11364462gladdens
gladder10398312gladder_
glades84820342gla_de_s
gladness1036152gladness
glancer103710072glancer_
glances104113142glance_s
glandered1236332glandered
glandless1134162glandless
glands85314402gland__s
glazers174410042gla_zers
glaziers18406562glaziers
gleaners9348072glean_ers
gliders94811842gl_iders
graders94716012gra_ders
grandees103211282grandees
grander93315872grander_
grandeurs11335112grandeurs
grangers103011972grangers
granters93614142granters
grinders103410422grinders
guarders1035882guarders
handers114224332_handers
inlanders1036142inlanders
islanders1035282islanders
ladders94115172_ladders
laders74927762_la_ders
lancers93616642_lancers
lander74028482_lander_
landlers94312832_landlers
lanners73618332_lanners
larders83516942_larders
lauders84012892_lauders
launders9358742_launders
lenders84419642_lenders
malanders1237022malanders
meanders1168832meanders
oleanders1035572oleanders
panders103423732_panders
planers94517942plan_ers
planners10399932planners
planters102915322planters
plunders11329832plunders
sanders84025942_sanders
slander84015442slander_
solanders1036962solanders
standers93514302standers
uplanders1234852uplanders
wanders114221332_wanders
zanders173015792_zanders

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 Filter1786911210590.390458182.1
2DLD Change Limit121059753.58033815.4
3Display Results75750.0302500.0
 (SQL Overall)178691754.00044672.8
 
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.