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

102 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
nickeling164539(None) 
nickelling1743641nickelling
nickering1636571nickering
nickling15278701nick_ling
bickering1837662bickering
dickering1737462dickering
nickelic1643272nickeli_c
nicking143516322nick__ing
picketing1835682picketing
pickling17239202pick_ling
sickening1635992sickening
sickling152910332sick_ling
snickering1744862snickering
ticketing1635632ticketing
tickling15309432tick_ling
bicycling1942883bicycling
bucketing1835713bucketing
buckling17259113buck_ling
cackling172610943cack_ling
chickening2244133chickening
cockering1839693cockering
cockling172310393cock_ling
cricketing1944033cricketing
dackering1737383dackering
dicking153617613dick__ing
dieseling1146143dieseling
docketing1785413docketing
duckling16247703duck_ling
flickering2044093flickering
hackling183310163hack_ling
heckling18257163heck_ling
hireling121210993hi_reling
hirseling1396273hirseling
inkling122911303_ink_ling
jacketing2345643jacketing
jockeying2663293jockeying
keckling14245523keck_ling
kicking133314023kick__ing
knuckling1542753knuck_ling
lackering1639373lackering
lackeying1934923lackeying
libeling1139873li_beling
lichening1545673lichening
licking144118283lick__ing
likening13246893li_kening
mackling172710063mack_ling
necking143913893neck__ing
neckline1496363neck_line
nibbling13256503ni_bbling
niching133612433nic__hing
nickel123811343nickel___
nickeled15115513nickel_ed
nickelled1653793nickelled
nickelous1553413nickelous
nickels13338653nickel__s
nicknaming1952113nicknaming
nictating1237573nictating
niddering1255323niddering
nidering10510483ni_dering
niffering1645133niffering
niggling11227443ni_ggling
nilling83619563ni__lling
nocking143615113nock__ing
packeting1836853packeting
pickaxing2543103pickaxing
pickeering1943533pickeering
picking163418333pick__ing
pinkening1634993pinkening
pocketing1875853pocketing
prickling1836533prick_ling
puckering1835883puckering
quickening2643163quickening
racketing1647873racketing
richening1546223richening
ricking143920233rick__ing
ridgeling12155263ridgeling
rocketing1666973rocketing
rockling15259383rock_ling
ruckling15258573ruck_ling
sicking143720173sick__ing
sicklying1943883sicklying
sideling101012183si_deling
slickening1743903slickening
snicking153610233snick__ing
sniveling1336033sni_veling
snorkeling1542973snorkeling
socketing1666383socketing
stickling1647003stick_ling
suckering1638103suckering
suckling152410023suck_ling
tackling153211123tack_ling
thickening2043283thickening
ticking143218753tick__ing
tinkering1437703tinkering
tinkling13239233tink_ling
tinseling1036643tinseling
trickling1647723trick_ling
tuckering1635693tuckering
unicycling1862843unicycling
whickering2343413whickering
wicking173414773wick__ing
winkling16298293wink_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.423422437.4
2DLD Change Limit1486411027.14020818.1
3Display Results1021020.0462217.4
 (SQL Overall)1786911027.60923484.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.