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 “gluing” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

91 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
gluing8381205(None) 
bluing94914481bluing
cluing93913501cluing
glueing9338711glueing
sluing74315881sluing
blueing103710202blueing
bluings10327962bluings
bluming123511282bluming
cling86424672cl_ing
clueing104110092clueing
clung86013602clu_ng
cuing85420192_cuing
eluding93412112eluding
eluting84115292eluting
feuing104412272feuing
fling97023512fl_ing
fluking154410512fluking
fluming133512792fluming
flung95114582flu_ng
fluting113815092fluting
fluxing18398922fluxing
flying134612152flying
gaeing84617222gaeing
gaging94718402gaging
galling93921962galling
gaming104622042gaming
gaping105618922gaping
gating84826952gating
gauging10339962gauging
gauming11319712gauming
gazing174717172gazing
geeing84313762geeing
gelding103911792gelding
gelling93219762gelling
gibing103712342gibing
gieing83614852gieing
gilding103813002gilding
gilling93520382gilling
giving114313882giving
glaring93714882glaring
glazing183611002glazing
gleying12318432gleying
gliding103911842gliding
gliming113310132gliming
glint66830182gl_int
globing113210002globing
glouting10379692glouting
gloving12308442gloving
glowing123211792glowing
glozing18338892glozing
glug66118012glu__g
glugging10316352glugging
gluier7310262gluier
gluily10308292gluily
gluon6311222gluon_
gluons738502gluons
glutting10247642glutting
going75218492g_oing
golfing12368942golfing
goring84119572goring
gouging103410702gouging
gulfing12339472gulfing
gulling94019562gulling
gulping11309752gulping
guying11379722guying
gybing13355922gybing
gyring113910362gyring
gyving14415712gyving
kluging13356592kluging
ling57447962_l_ing
lubing94114032_lubing
luging83915292_luging
lung55732492_lu_ng
luring73820752_luring
luting75221752_luting
lying95717452_lying
muling93519882muling
ogling83211882ogl_ing
pluming123412042pluming
plying124312082plying
puling93621402puling
regluing1077032regluing
ruing67221052_ruing
ruling73219552ruling
sling66028802sl_ing
slung65117832slu_ng
spuing94313362spuing
suing65026362_suing
truing73913932truing
ungluing1035862ungluing
valuing11298842valuing

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 Filter178691825510.1231452772.4
2DLD Change Limit82551917.59610867.7
3Display Results91910.093978.5
 (SQL Overall)178691917.81222873.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.