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

48 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
globular114338(None) 
globulars1242451globulars
lobular936671_lobular
bilobular1392422bilobular
globule1034382globul_e
globules1135412globules
globulin1144192globulin
locular938962_locular
alular6311363al__ular
anovular1144163anovular
bilocular1363693bilocular
biovular1343613biovular
copular113810613_copular
fabular12288703_fabular
fibular12267983_fibular
glabellar1243243glabellar
glandular1142793glandular
global937663glob__al
globally1444613globally
globbier1334243globbier
globulins1244173globulins
glomerular1351353glomerular
gobbler123310023g_obbler
granular946903granular
grossular1042773grossular
gular6314833g___ular
jocular1637313_jocular
ligular8348533_ligular
lobar7313013_lob__ar
lobularly1462693_lobularly
lobulate1078833_lobulate
lobule82910063_lobul_e
lobules92510813_lobules
lunular736023_lunular
modular1087363_modular
morular978223_morular
nebular956493_nebular
nodular876703_nodular
ocular8610143__ocular
ovular946833__ovular
pabular11259483_pabular
planular1044763planular
plumular1243303plumular
popular11319573_popular
sporular1065233sporular
tabular9279773_tabular
tubular9267483_tubular
zonular1656493_zonular

Search took 8 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 Limit146162487.14020470.9
3Display Results48480.0163000.0
 (SQL Overall)178691487.57923577.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.