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

89 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
glonoin87567(None) 
glonoins955841glonoins
glenoid937802glenoid
globin9309722glo_bin
globoid1145972globoid
gonion73612832g_onion
alanin6317273alan_in
aloin55227423al__oin
blondine1137153blondine
blooie83913193blo_oie
clonic104914673clon_ic
cloning103215473clon_ing
clonking153810153clonking
cojoin1539503_cojoin
conin76232723_con_in
conjoin1638203_conjoin
conoid9818883_conoid
eloin55923203el__oin
flooie93712153flo_oie
florin9312653flo_rin
ganoid8314443g_anoid
glancing1247063glancing
gliadin935593gliadin
glinting103210053glinting
gloaming12268013gloaming
gloating102611463gloating
globing113210003glo_bing
globins10278953glo_bins
globoids1244413globoids
globose1035543globose
globous1036503globous
globulin1144193globulin
glochid1445263glochid
glomming14275923glomming
gloom87116523glo_o_m
glooming12358013glooming
glooms96211683glo_oms
gloomy12528763glo_omy
glopping14307753glopping
gloria71910553glo_ria
glorying1335543glorying
glossina9275543glossina
glossing10278883glossing
glottic1036653glottic
glottis837173glottis
glouting10379693glouting
gloving12308443glo_ving
glowing123211793glo_wing
glozing18338893glo_zing
gluon6311223gl_uo_n
glycin1235963gl_ycin
gnomon936183gnomo_n
goblin939503g_oblin
godown1136033g_odown
gonging103713033g_onging
gonia64117533g_on_ia
gonif94320923g_on_if
gonof95218653g_ono_f
gonofs10459863g_onofs
gonoph1235403g_onoph
goon57236173g_o_o_n
goonie73615563goon_ie
groin65521083g__roin
grunion835433grunion
guanin7610803guan_in
guenon736403gueno_n
lanolin7310643_lanolin
linin58025523_lin_in
locoing102810973_locoing
login66025003_lo_gin
logion76013723_logion
logoi69715943_logoi_
logon615922313_logo_n
loin46838723_l__oin
lomein8410203_lomein
longan75612363_longan
longing93915783_longing
looie55624243_lo_oie
looing73621043_lo_oing
loon47344793_lo_o_n
loonie64216453_loonie
lotion65716523_lotion
onion54320973__onion
phonon114012033phono_n
plonking15358563plonking
plosion939113plosion
pronoun939033pronoun
ronion63315643_ronion
spongin1036373spongin

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.436409841.7
2DLD Change Limit134027897.09318895.7
3Display Results89890.0332697.0
 (SQL Overall)178691897.56223630.1
 
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.