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

84 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
kerneling146440(None) 
kenneling1464081kenneling
kernelling1584141kernelling
creneling1247732creneling
ferreling13136272ferreling
keeling123515122ke__eling
kennelling1573862kennelling
kerning124010892kern__ing
aneling82719503__aneling
barreling1238043barreling
beveling143011033be_veling
corbeling1439033corbeling
cornering12311893cornering
creeling113513363_creeling
crenelling1345683crenelling
defueling14255093defueling
derailing112011313derailing
develing133212733de_veling
eanling81416673_ean_ling
erelong835593_er_elong
feeling113617073fe__eling
ferrelling1445063ferrelling
ferreting13127703ferreting
ferruling13134423ferruling
feruling1258873fer_uling
funneling1344513funneling
garnering11298083garnering
gentling1048453ge_ntling
greenling1136753greenling
grueling1078273_grueling
heeling113618513he__eling
hireling121210993hir_eling
hirseling1396273hirseling
jeweling1935483je_weling
keckling14245523ke_ckling
keeking114210893ke__eking
keening123713153ke__ening
keeping144012543ke__eping
kegling13309363ke__gling
kenning124010543ke_n_ning
kerbing14308483ker__bing
kerfing15307533ker__fing
kernel104010593kernel___
kerneled1344033kernel_ed
kernelled1443743kernelled
kernelly1543933kernel_ly
kernels11417953kernel__s
keynoting1742813keynoting
kindling14229623k_indling
kirning12319333kirn__ing
kneeing12226523k__neeing
kneeling13287783k_neeling
knelling13319023k__nelling
kraaling13186663k_raaling
leveling122910433le_veling
marveling1537103marveling
morseling1238073morseling
paneling111013623_paneling
parceling1438443parceling
peeling102919873pe__eling
periling11316863per_iling
perilling12410003perilling
reeling83126863__reeling
refeeling13229313refeeling
refueling13227973refueling
reheeling13218263reheeling
reneging102111533re_neging
renewing121910713re_newing
repaneling1345733repaneling
rerenting102617663rerenting
rerolling102210373rerolling
reveling123117083re_veling
seeling83522003se__eling
streeling10189483streeling
teaseling1036913teaseling
teazeling1934543teazeling
telneting1035593telneting
tunneling1034693tunneling
unkenneling1651623unkenneling
unreeling1038983unreeling
weanling12118643wean_ling
weaseling1335613weaseling
wedeling1338773we_deling
yeanling12107063yean_ling

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 Filter1786911486410.420425454.8
2DLD Change Limit148641847.14020818.1
3Display Results84840.0332545.5
 (SQL Overall)178691847.59323533.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.