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
lobular936661_lobular
bilobular1392412bilobular
globule1034382globul_e
globules1135412globules
globulin1144192globulin
locular938952_locular
alular6311353al__ular
anovular1144163anovular
bilocular1363683bilocular
biovular1343603biovular
copular113810603_copular
fabular12288693_fabular
fibular12267973_fibular
glabellar1243243glabellar
glandular1142783glandular
global937663glob__al
globally1444613globally
globbier1334243globbier
globulins1244173globulins
glomerular1351353glomerular
gobbler123310023g_obbler
granular946893granular
grossular1042763grossular
gular6314833g___ular
jocular1637303_jocular
ligular8348533_ligular
lobar7313013_lob__ar
lobularly1462693_lobularly
lobulate1078833_lobulate
lobule82910063_lobul_e
lobules92510813_lobules
lunular736013_lunular
modular1087363_modular
morular978223_morular
nebular956483_nebular
nodular876703_nodular
ocular8610133__ocular
ovular946833__ovular
pabular11259473_pabular
planular1044753planular
plumular1243303plumular
popular11319563_popular
sporular1065223sporular
tabular9279763_tabular
tubular9267473_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.36019859.0
3Display Results48480.0133692.3
 (SQL Overall)178691487.79622920.9
 
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.