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

70 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
gangland114519(None) 
ganglands1244451ganglands
gangbang1342962gangbang
gangling112411402gangling
gangplank17111782gangplank
garland948702ga_rland
rangeland1143382rangeland
aland65526413_a__land
angled84219093_angl_ed
angling92816043_angling
backland1748103backland
badland1147653ba_dland
dangled104013153dangl_ed
dangling112611233dangling
duneland1043343duneland
farmland1454233farmland
fenland1135693fen_land
gaggled11359913gaggl_ed
gaggling10217463gaggling
gagman103811243ga_gman_
gallant83517113ga_llant
gamelan10106643gamelan_
gamelans11115843gamelans
gangbanged1661543gangbanged
gangbangs1442623gangbangs
ganged94619193gang__ed
ganging103216193gang_ing
ganglia946613gangl_ia
ganglial1054663ganglial
gangliar1064123gangliar
gangliate1144493gangliate
ganglier1047603ganglier
ganglion1044393ganglion
ganglions1144063ganglions
gangly113911583gangl__y
gangplanks1871553gangplanks
gangrene1044363gangrene
gangrened1242733gangrened
gangway1544233gangwa_y
gangways1643733gangways
gantline9410903gantline
gargled104210673gargl_ed
gargling11239203gargling
garlands1038323ga_rlands
gland75217713___gland
grassland1153473grassland
hangman1337813hangman_
inland7310313_in_land
jangled164111563jangl_ed
jangling17249623jangling
lalland83810183la_lland
langlauf1243773langlauf
longhand1344493longhand
mainland1145213mainland
mangled113615263mangl_ed
mangling122312623mangling
parkland1545373parkland
pineland1145893pineland
raglan73711503ra_glan_
raglans82410133ra_glans
rangelands1242793rangelands
sunland837473sun_land
tangled94214633tangl_ed
tangling101712543tangling
vanguard1343893vanguard
wangan10311223wang_an_
wangans1149503wang_ans
wangled123312413wangl_ed
wangling132310993wangling
yardland1343763yardland

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.440406115.9
2DLD Change Limit146162707.56019333.6
3Display Results70700.0332121.2
 (SQL Overall)178691708.03322244.6
 
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.