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

58 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
danglers10361059(None) 
anglers84014821_anglers
dandlers103912051dandlers
dangers94818211dang_ers
dangler96912811dangler_
dangles93618421dangle_s
janglers16319371janglers
manglers113311901manglers
tanglers92911971tanglers
wanglers123310031wanglers
angers75222542_ang_ers
angler74017862_angler_
angles74426702_angle_s
antlers74014742_antlers
bangers104020352bang_ers
bangles103617412bangle_s
bunglers11398482bunglers
candlers114214102candlers
dabblers13379362dabblers
daggers103714912da_ggers
daggles103611912daggle_s
dancers103413092dan_cers
danders93921182dan_ders
dandler94414272dandler_
dandles94218532dandle_s
danger83722822dang_er_
dangle84119302dangle__
dangled104013152dangle_d
danglier1056752danglier_
dawdlers13375672dawdlers
dazzlers1733232dazzlers
dingers94321382ding_ers
dingles93818322dingle_s
dongles93212872dongle_s
fangless1237662fangless
gangers94418602gang_ers
garglers10418262garglers
hagglers13326622hagglers
handlers124014142handlers
hangers113120812hang_ers
jangler153811832jangler_
jangles154015682jangle_s
jinglers16408762jinglers
landlers94312832landlers
langleys1245102langleys
mangers103521262mang_ers
mangler103215642mangler_
mangles104021462mangle_s
minglers113011292minglers
rangers83621042rang_ers
sangers84421942sang_ers
tangler83515072tangler_
tangles83920042tangle_s
tinglers93710592tinglers
twanglers1363432twanglers
wangler113312652wangler_
wangles113416932wangle_s
wranglers1344272wranglers

Search took 4 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.1401276364.3
2DLD Change Limit121059583.62633386.4
3Display Results58580.0134461.5
 (SQL Overall)178691583.77947285.3
 
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.