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

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

63 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
lanthorn114719(None) 
lanthorns1246011lanthorns
althorn1047762_althorn
hawthorn1743552hawthorn
lantern7310012lant_ern
lastborn1044132lastborn
longhorn1245422longhorn
alphorn1246393_alphorn
althorns1146733_althorns
anchor113911973_anchor_
anchors123912953_anchors
anther93715063_anther_
anthers103715203_anthers
anthoid11313313_anthoid
antiporn1048473_antiporn
attorn6310793_a_ttorn
author939763_author_
authors10311853_authors
benthon1237693bentho_n
bethorn1238643_bethorn
blackthorn2172103blackthorn
boxthorn2043693boxthorn
canton85722993cant_o_n
cantor85621523cant_or_
cantors94620753cant_ors
earthborn1443133earthborn
hartshorn1543643hartshorn
hawthorns1842823hawthorns
hawthorny2151553hawthorny
inkhorn1444363_inkhorn
landform1445223landform
landlord1045163landlord
languor895423languor_
languors976153languors
lanterns838303lant_erns
lanthanon1252623lanthanon
lastborns1143383lastborns
lather95124353la_ther_
lathers104321883la_thers
lathery133911123la_thery
lathwork1845633la_thwork
leathern11398913leathern
leghorn1146223l_eghorn
longhorns1344133longhorns
luthern1037653l_uthern
pantheon1346313pantheon
panther12611443panther_
panthers13510783panthers
ramshorn1343923ramshorn
santoor737433santoor_
santoors837633santoors
saxhorn1744223sa_xhorn
thorn85318703___thorn
tinhorn1046033tin_horn
unshorn1036943_unshorn
untorn63012343_unt_orn
wanton94413813want_o_n
xanthan1736013xanth_an
xanthein1845013xanthein
xanthin1747043xanth_in
xanthoma2043973xanthoma
xanthone1847113xanthone
xanthous1846643xanthous

Search took 9 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 Filter1786911461620.420425454.8
2DLD Change Limit146162637.86018595.7
3Display Results63630.0163937.5
 (SQL Overall)178691638.29621539.4
 
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.