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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

132 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
glibness113413(None) 
gelidness1144472gelidness
gladness1036152gladness
glegness1034612glegness
glibbest1343682glibbest
glibnesses1344752glibnesses
gluiness937362gluiness
glumness1135202glumness
grimness1175992grimness
lioness739102_lioness
slimness1036522slimness
ugliness936862ugli_ness
acidness1136723acidness
agileness1046493agileness
algidness1144273algidness
alibies9313323alibie_s
alienees8118653alienees
alieners889823alieners
alienness945373alienness
aligners9117573aligners
alikeness1336333alikeness
aliners74717723ali_ners
alines65735223ali_ne_s
aliveness1238223aliveness
aridness939223aridness
avidness1246113avidness
bibless11439173_bibless
bigness1038193_bigness
blindness1235343blindness
blueness1038213blueness
chicness1535593chicness
clines84926043cli_ne_s
dimness1038843_dimness
drabness1135803drabness
dumbness1334613dumbness
evilness1135043evilness
fairness1136563fairness
fitness10299393_fitness
flatness1138153flatness
fluidness1344293fluidness
gabbiness1434403gabbiness
gainers84214593gai_ners
gainless9117403gainless
gameness112810693gameness
gaminess112911063gaminess
garbless11388253garbless
gastness9278473gastness
gayness1136843g_ayness
giantess933893g_iantess
gibbers124710983g_ibbers
gibbets12417723g_ibbets
gibers95114663g_ib_ers
gibes84422523g_ib_e_s
giblets103210423g_iblets
gillnets934733gillnets
ginners84314223g_inners
glariness1038553glariness
glaziness1935753glaziness
gleaners9348073gleaners
glebeless1242953glebeless
glebes95512243gleb_e_s
glibber1235163glibbe_r
gliders94811843gli_ders
glides84518863gli_de_s
glimes94717523gli_me_s
glimmers13396153glimmers
glimpses1343953glimpses
glints75714213gli_n_ts
glistens9366593glistens
glisters93912603glisters
glitters93710543glitters
glitzes17367563glitze_s
globes94314543glob_e_s
glueyness1342913glueyness
godliness1136593godli_ness
goneness9310763goneness
goodness1036253goodness
goriness9310753goriness
grayness1235933grayness
greyness1235243greyness
griminess1236703griminess
grinners9288043grinners
guineas836753gui_neas
hipness12277383_hipness
holiness112512503holi_ness
iciness938863ici_ness
illness736473il_lness
laxness1436043_laxness
lianes63819323_liane_s
libbers113812833_libbers
libels85112693_lib_els
libers84721443_lib_ers
lidless8309273_lidless
likeness12229863_likeness
limbless12246313_limbless
liminess10510643_liminess
limners93311563_limners
limpness1246703_limpness
linens64818393_li_nens
liners65428853_li_ners
lines57054573_li_ne_s
linnets739833_linnets
lipless9259553_lipless
liteness82213213_liteness
liveness112411393_liveness
lowness1037813_lowness
mildness1136523mildness
numbness1234413numbness
oiliness8311563oiliness
oldness836403ol_dness
plainness1155183plainness
plumbness1543133plumbness
primness1276763primness
ribless93410343_ribless
slickness1535903slickness
sliminess1137423sliminess
slipless10246993slipless
slitless8268143slitless
slowness1135013slowness
slyness1035263sl_yness
snubness1044373snubness
solidness1036903solidness
thinness11277163thinness
trigness968403trigness
trimness1067563trimness
vainness1136063vainness
validness13125363validness
vileness1139983vileness
voidness1235553voidness
wildness1236203wildness
wiliness1139113wiliness
witness103010013_witness

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 Limit1461621326.98320931.1
3Display Results1321320.0462869.6
 (SQL Overall)1786911327.45223978.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.