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

54 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
jugulars164323(None) 
jugular1534511jugular_
jaguars1535232jagu_ars
jugglers17366522jugglers
jugula1434982jugula__
jugulate1645482jugulate
jugulates1744602jugulates
regulars936252regulars
uvulars1044412_uvulars
angular838533angular_
arugulas943913arugula_s
augurers9114813augurers
augurs7399963augu__rs
bugbears1333693bugbears
buglers105115323bug_lers
burglars1154593burglars
cupular11317623cupular_
guars65021053__gu_ars
gulags837543__gulags
gular6314833__gular_
insulars8137323insulars
jaguar1435283jagu_ar_
jocular1637303jocular_
jogglers17356883jogglers
jugfuls1843063jugful__s
juggler16418873juggler_
jugglery20303813jugglery
juggles164510843juggl_es
jugheads2042923jugheads
jugulated1844023jugulated
jugulum1742503jugul_um
jugums16104673jugu__ms
jumblers19358323jumblers
ligular8348533ligular_
ligulas8329173ligula_s
lunular736013lunular_
modulars1165833modulars
muggars11316643mug_gars
mutular936643mutular_
oculars948363_oculars
regular838423regular_
rugolas836373rugola_s
seculars10219393seculars
simulars1047073simulars
singulars10305633singulars
sugars7312423sug__ars
tegular836603tegular_
titulars845863titulars
tubular9267473tubular_
tumular9236543tumular_
tutelars844993tutelars
ungular836773ungular_
uvular955563_uvular_
uvulas946523_uvula_s

Search took 7 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.423422437.4
2DLD Change Limit146162546.15623743.0
3Display Results54540.0301800.0
 (SQL Overall)178691546.60927037.5
 
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.