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

93 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
kenneling146408(None) 
kennelling1573861kennelling
kerneling1464401kerneling
funneling1344512funneling
keeling123515122ke__eling
kenning124010542kenn__ing
kernelling1584142kernelling
kneeling13287782k_neeling
tunneling1034692tunneling
unkenneling1651622unkenneling
aneling82719503__aneling
angeling102811733_angeling
annealing1047453_annealing
annexing1635473_annexing
bannering12208803bannering
beveling143011033be_veling
bonneting1236173bonneting
canceling14310163canceling
centering122915143centering
channeling1645203channeling
creneling1247733creneling
defueling14255093defueling
denning93515173denn__ing
develing133212733de_veling
eanling81416673_ean_ling
enabling1138603_enabling
enameling1246123_enameling
enisling949633_enisling
ennobling1244123_ennobling
ensiling9410723_ensiling
entering91920053_entering
feeling113617073fe__eling
fenagling1434553fenagling
ferreling13136273ferreling
flanneling1443813flanneling
funnelling1444243funnelling
gendering12249753gendering
gentling1048453ge_ntling
hanseling1338063hanseling
heeling113618513he__eling
hennaing1234993henn_aing
jeweling1935483je_weling
keckling14245523ke_ckling
keeking114210893ke__eking
keening123713153ke__ening
keeping144012543ke__eping
kegling13309363ke__gling
kennel10369223kennel___
kenneled1334003kennel_ed
kennelled1443503kennelled
kennels11387193kennel__s
kennings13315273kenn__ings
kerning124010893kern__ing
keynoting1742813keynoting
kindling14229623k_indling
kneeing12226523k__neeing
knelling13319023k_nelling
knolling13206893k_nolling
knurling1344943k_nurling
leveling122910433le_veling
paneling111013623_paneling
peeling102919873pe__eling
penciling1437413penciling
penning103616493penn__ing
reannexing1843153reannexing
reeling83126863re__eling
refeeling13229313refeeling
refueling13227973refueling
reheeling13218263reheeling
renailing102813333renailing
rendering112213183rendering
reneging102111533re_neging
renewing121910713re_newing
repaneling1345733repaneling
reveling123117083re_veling
seeling83522003se__eling
sentineling1273373sentineling
sonneting1037003sonneting
teaseling1036913teaseling
teazeling1934543teazeling
telneting1035593telneting
tendering112210813tendering
tentering102313203tentering
tinseling1036643tinseling
tunnelings1142493tunnelings
tunnelling1144383tunnelling
unkennelling1751143unkennelling
veneering1337663veneering
weanling12118643wean_ling
weaseling1335613weaseling
wedeling1338773we_deling
yeanling12107063yean_ling
yenning11369493yenn__ing

Search took 7 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 Filter1786911486410.420425454.8
2DLD Change Limit148641936.04624585.0
3Display Results93930.0332818.2
 (SQL Overall)178691936.49927495.2
 
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.