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

94 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
globoid114597(None) 
globoids1244411globoids
glenoid937802glenoid
globed104811762glob_ed
globin9309722glob_in
globose1035542globose
globous1036502globous
glochid1445262glochid
glonoin875672glonoin
gobioid1146022g_obioid
algoid83011473al_goid
ameboid1277233ameboid
amoeboid1344113amoeboid
blobbed11366563blobbed
blood85319523blo_o_d
blooie83913193blo_oie
ceboid11310653_ceboid
choroid13311803choroid
colloid10312883colloid
conoid9818883_conoid
cuboid1139503_cuboid
flood95215603flo_o_d
flooie93712153flo_oie
florid10311453flo_rid
gabbroid1452763gabbroid
gadoid9310463g_adoid
ganoid8314443g_anoid
garboil1036513garboil
geoid74215763g__eoid
gloated93511533gloated
glob76623393glob___
global937663glob_al
globate1057823globate
globated1265753globated
globbier1334243globbier
globby1434683glob_by
globe84917013glob__e
globes94314543glob_es
globing113210003globing
globins10278953globins
globosity1542733globosity
globs85616403glob__s
globule1034383globule
globulin1144193globulin
glochids1543953glochids
glommed13265443glommed
glonoins955843glonoins
gloom87116523glo_o_m
gloomed11337413gloomed
glooms96211683glo_oms
gloomy12528763glo_omy
glopped13347613glopped
gloria71910553glo_ria
gloried9169523gloried
glossed94410073glossed
glottic1036653glottic
glottis837173glottis
glouted9429713glouted
gloved114811873glo_ved
glowed114913833glo_wed
glozed173711223glo_zed
gobbed124613883g_obbed
gobioids1243873g_obioids
goblin939503g_oblin
gobo76126903g_obo__
goboes95914443g_oboes
gobony1236913g_obony
gobos86219383g_obo_s
good66531803g_o_o_d
groupoid1243263groupoid
gumboil1244373gumboil
hoboed124511683_hoboed
kobold1365963_kobold
labroid1038823_labroid
lipoid9411043_lipoid
lobbed113114613_lobbed
lobbied12337173_lobbied
lobed86022133_lob_ed
lobo67229863_lobo__
lobos75921843_lobo_s
locoed94312193_locoed
logoi69715943_logoi_
loid55531503_l__oid
looed64626133_lo_oed
looie55624243_lo_oie
obovoid1342783obovoid
ovoid94811023__ovoid
placoid1239773placoid
rhomboid1643843rhomboid
sloid64619713sl__oid
sporoid102310733sporoid
toroid7416013_toroid
toxoid1438153_toxoid
zooid15312103_zo_oid

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 Filter1786911340270.440406115.9
2DLD Change Limit134027946.59320328.7
3Display Results94940.0303133.3
 (SQL Overall)178691947.06325299.6
 
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.