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

145 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
knowings1623403(None) 
knowing15287671knowing_
bowings133612002_bowings
gnawings13263772gnawings
knottings14243072knottings
knowinger1741902knowinger
knowingest1852292knowingest
knowingly2043462knowingly
knowns13426442know_n_s
lowings113710072_lowings
mowings13328482_mowings
nosings8349592_nosings
rowings113710362_rowings
showings15246882showings
snowing113913452snowing_
unknowings18191552unknowings
anglings10228273anglings
anoints7311063ano_ints
antings85015583an_tings
avowing1466603avowing_
blowing133813053blowing_
bodings113711653_bodings
boings96416873_bo_ings
bondings12369413bondings
bookings15358733bookings
borings103614243_borings
bowing124723063_bowing_
bowlings14408753_bowlings
boxings17429163_boxings
brewings14296693brewings
brokings15317713brokings
chowing164412773chowing_
clonings11307433clonings
closings11277673closings
comings124013533_comings
cookings15358603cookings
copings124111843_copings
covings134511243_covings
cowing124526323_cowing_
cowlings14359773_cowlings
crowing133814763crowing_
doings84913183_do_ings
dopings11408783_dopings
dowing114221513_dowing_
drawings13386283drawings
endings92910443en_dings
endowing13178173endowing_
entwines1148753entwines
enwinds11255553en_winds
flowing143411763flowing_
footings12248833footings
fowlings15377243_fowlings
foxings18446963_foxings
gaywings1633193gaywings
glowing123211793glowing_
gnawing12377903gnawing_
goings84911523_go_ings
growing123512473growing_
inbeings1134603inbeings
incomings1445213incomings
indowing13198083indowing_
inklings13246383inklings
innings8329443in_nings
inosines8312703inosines
intwines1138043intwines
inwinds11216273in_winds
ironings9217583ironings
jowing174216043_jowing_
kaoliangs1441663kaoliangs
kaolines1239293kaolines
kaolins1139363kaolin_s
kartings13418523kartings
keepings15345943keepings
keglings14245233keglings
kennings13315273kennings
killings133710483killings
kiltings13327083kiltings
kindlings15195273kindlings
kings105825563k___ings
kitlings13318103kitlings
klongs11436603klo__ngs
kneeing12226523kneeing_
knifing1536483knifing_
knittings14273453knittings
knocking14245943knocking_
knolling13206883knolling_
knotting13236573knotting_
knouting13226793knouting_
knowers1436343know_ers
knowingness1952173knowingness
known12568343know_n__
knows124912413know___s
koines10415733k_o_ines
konking113510213konking_
kotowing1634013kotowing_
lapwings14274973lapwings
lawings113611473_lawings
longings10408563longings
losings82810623_losings
lowing104623273_lowing_
meowing1368593meowing_
moorings11257713moorings
mowing124119093_mowing_
noggings11285743_noggings
noonings9246653noonings
nosing73419843_nosing_
nothings12266683_nothings
noting74120153_noting_
oncomings1444233oncomings
owing96222723__owing_
plowing133111723plowing_
redwings13305733redwings
roofings12256023roofings
rovings11439493_rovings
rowing103623303_rowing_
scowing133812093scowing_
sewings11369173_sewings
shorings12269483shorings
showing143814663showing_
showrings1644063showrings
skiorings14243793skiorings
slowing112814743slowing_
snawing113612483snawing_
snoring83917203snoring_
snowiness1296243snowiness
sorings83817253_sorings
sowing104222913_sowing_
stowing113315133stowing_
swings104714453__swings
toolings9248473toolings
towing103823193_towing_
trowing113413703trowing_
unbowing1436993unbowing_
undoings1035793undoings
unknowing17103583unknowing_
unslings937283unslings
untwines1137603untwines
unwinds11286733un_winds
upswings1433003upswings
viewings1533983viewings
vowing133715273_vowing_
waxwings2232953waxwings
wings95727243___wings
wowing133915393_wowing_
yowing133715543_yowing_

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.1601116818.8
2DLD Change Limit1461621457.09320606.5
3Display Results1451450.0463152.2
 (SQL Overall)1786911457.29924481.6
 
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.