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 “glonoins” 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
glonoins95584(None) 
glonoin875671glonoin_
globins10278952glo_bins
globoids1244412globoids
alanins7315803alan_ins
aloins65022203al__oins
blondine1137153blondine
blondines1246153blondines
cloning103215473clon_ing
clonings11307433clon_ings
clonking153810153clonking
cojoins1638993_cojoins
conins84327233_con_ins
conjoins1738133_conjoins
conoids10813883_conoids
eloins65419383el__oins
florins10311643flo_rins
ganoids939333g_anoids
glancing1247063glancing
glenoid937803glenoi_d
gliadins1035193gliadins
glinting103210053glinting
gloaming12268013gloaming
gloamings13254093gloamings
gloating102611463gloating
globin9309723glo_bin_
globing113210003glo_bing
globoid1145973globoi_d
globous1036503globo_us
globulins1244173globulins
glochids1543953glochids
glomming14275923glomming
glooming12358013glooming
gloomings13283973gloomings
glooms96211683glo_o_ms
glopping14307753glopping
glorias81610323glo_rias
glories81915923glo_ries
glorious946823glorious
glorying1335543glorying
glossies93311253glossies
glossina9275543glossina
glossinas10214143glossinas
glossing10278883glossing
glottis837173glotti_s
glouting10379693glouting
gloving12308443glo_ving
glowing123211793glo_wing
glozing18338893glo_zing
gluons738503gl_uo_ns
glycins1335563gl_ycins
gnomons1035753gnomo_ns
goblins1039243g_oblins
godowns1234673g_odowns
gonging103713033g_onging
gonifs104310133g_on_ifs
gonion73612833g_onion_
gonofs10459863g_ono_fs
gonophs1344453g_onophs
goonies83618333goon_ies
goons65326773g_o_o_ns
groins73917203g__roins
grunions945353grunions
guanins8810013guan_ins
guenons836563gueno_ns
lanolins8310533_lanolins
linins65922143_lin_ins
locoing102810973_locoing
logins77820643_lo_gins
logions86211293_logions
logons79818173_logo_ns
loins56728423_l__oins
lomeins969483_lomeins
longans84510813_longans
longies82916553_longies
longing93915783_longing
longings10408563_longings
looies65025833_lo_oies
looing73621043_lo_oing
loonies73919543_loonies
loons55731723_lo_o_ns
lotions74614763_lotions
onions64016433__onions
phonons123310253phono_ns
plonking15358563plonking
plosions1038023plosions
pronouns1047203pronouns
ronions73313343_ronions
spongins1136563spongins

Search took 10 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.420425454.8
2DLD Change Limit146162898.89316435.6
3Display Results89890.0302966.7
 (SQL Overall)178691899.34319125.7
 
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.